PeopleSoft Common Tables for Operational Reporting Campus Solutions This document contains a list of table (record) names that, based on security roles, college staff can use to build PS Query reports in the Campus Solutions pillar. Includes: Academic Structure Admissions and Recruitment Financial Aid Student Financials Campus Community Course and Class Management Student Records
2014
ctcLink Reporting and Analytics Washington State Board for Community and Technical Colleges
8/4/2014
Page 1 of 11 revised 11/9/2016
Superscript key: E = Effective-dated table; I = Institution field in table; P = Prompt table
PEOPLESOFT CAMPUS SOLUTIONS COMMON TABLES I. Academic Structure
Table Name Description
INSTITUTION_TBLP Lookup table for Institution prompt at run-time
TERM_VAL_TBLP Lookup table for Term prompt at run-time
AID_YEAR_TBLP Lookup table for Financial Aid Year (data pending go-live)
II. Admissions and Recruitment
Applicants (data pending go-live)
Table Name Description
ADM_APP_CAR_SEQ Application career sequence (stores next available career number (0, 1, 2...)
ADM_APPL_DATA Application data
ADM_APPL_PLAN Application plan
ADM_APPL_PROG Application program
ADM_APPL_DATA joined to ADM_APPL_PROG
Common Admissions join between admissions application and program data
ADM_APPL_RCR_CA Recruiting category
Prospects (data pending go-live)
Table Name Description
ADM_PRSPCT_CAR Prospect career
ADM_PRSPCT_PLAN Prospect plan
ADM_PRSPCT_PROG Prospect program
Page 2 of 11 revised 11/9/2016
Superscript key: E = Effective-dated table; I = Institution field in table; P = Prompt table
III. Financial Aid
ISIR-related
Table Name Description
ISIR_00_1_EC 1999-2000 ISIR Sect 1 EC
ISIR_00_2_EC 1999-2000 ISIR Sect 2 EC
ISIR_00_3_EC ISIR Sect 3 EC
ISIR_COMMENTSE ISIR Comment Codes
ISIR_COMMT_TBL ISIR Comment Descriptions
ISIR_COMPUTED Computed Data from INAS/DOE
ISIR_CONTROLE, P ISIR Internals/Control Data
ISIR_PARENTE, I Fed Parent Application Data
ISIR_STUDENTE Fed Student Application Data
Financial Aid Awards and Packaging
Table Name Description
STDNT_FA_TERM Student Fin Aid Term Table
STDNT_TERM_BDGT Student Term Budget
STDNT_AWARDS Student Awards
STDNT_AWRD_ACTV Student Award Activity
STDNT_AWRD_DISB Student Award Disbursements
STDNT_AID_ATRBT Student Aid Attributes Table
STDNT_PKG_VAR Student Packaging Variables
STDNT_BGT_IT_VW Student Budget Item Summary
ITEM_TP_FA_AWRD Item To Prompt for Awards
ITEM_TP_FA_DISB Item Type Disb Plan/Split Cd
ITEM_TP_FA_PKG Item Tp Prompt for Packaging
SFA_ASG_ELIG ACG/SMART Eligibility
SFA_ASG_ORG ACG/SMART Origination Record
Page 3 of 11 revised 11/9/2016
Superscript key: E = Effective-dated table; I = Institution field in table; P = Prompt table
IV. Student Financials
Accounts
Table Name Description
ACCOUNT_SF Student account
ITEM_SF Student account items
ITEM_LINE_SF Student account item lines
ITEM_XREF Student item cross reference
PAYMENT_TBL Student payments
QUICK_POST_TBL Quick post setup
QUICK_POST_ERR Quick post errors
ADM_APPL_DEP Calculated deposit fees (e.g. student housing, tuition deposit) as distinct from full charges
Billing
Table Name Description
BI_BILL_HEADER Billing Invoice Header
BILL_HEADER_VW Billing Invoice Header View
BILL_HEADER_VW2 Billing Invoice Header View
BI_BILLING_LINE Billing Line
BI_BILL_MESSAGE Bill Messages
BI_STD_REQ_TBL Billing Standard Request Table
Credit History and Collections
Table Name Description
CREDIT_HISTORY Student Credit history
COLLECTION_SF Student collections
COLL_LTR_ITEM Dunning/collection letters
COLLECT_EFFORT Student collections recovery effort data
Page 4 of 11 revised 11/9/2016
Superscript key: E = Effective-dated table; I = Institution field in table; P = Prompt table
Cashiering
Table Name Description
CSH_BD_CSH_TBL Business Date Cashier Table
CSH_BD_CSH_OPEN Business Date Cashier Open Table
CSH_BD_REG_OPEN Business Date Register Open Table
CSH_BD_REG_TBL Business Date Register Table
CSH_OFF_RECEIPT Cashier Office Receipts
CSH_OFF_RCPT_L Cashier Office Receipt Line
CSH_OFF_RCPT_T Cashier Office Receipt Tender
CSH_OFF_TBL Cashiering Office Table
GL Interface
Table Name Description
SF_ACCTG_LN SF Accounting Line
Group Post
Table Name Description
GROUP_CONT_INFO Control Group Info
GROUP_LINE Group Line Information/Check
Item Types
Table Name Description
ITEM_TYPE_TBL Item Type Table
ITEM_ACCT_TYPE Valid Account Types
GL_INTERFACE General Ledger Interface
Refunds
Table Name Description
REFUND_HDR Refund Header
REFUND_DTL Refund Detail
Page 5 of 11 revised 11/9/2016
Superscript key: E = Effective-dated table; I = Institution field in table; P = Prompt table
Optional Fees
Table Name Description
OPT_FEE_STDNT Optional Fees by Student
OPT_FEE_TBL Optional Fees Table
OPT_FEE_TERM Optional Fee Terms
OPT_FEE_VAL Optional Fee Values
Third Party Contracts/Deferral Contracts/Payment Plans
Table Name Description
TP_CHARGES Third Party Allowable Charges
TP_CONTRACT Third Party Contracts
TP_STUDENT Third Party Student
TP_STDNT_CHRG Third Party Allowable Charges Student
Tuition Calculation
Table Name Description
TUIT_CALC_TBL Tuition Calc Table
CALC_MESSAGES Tuition Calc Error/Warn Messages
OPT_FEE_STDNT Optional Fees by Student
Term Fee Setup
Table Name Description
TERM_FEE_TBL Term Fee Table
TERM_FE_CD_TBL Term Fee Code Table
TERM_SF_CD_TBL Term Sub Fee Code Table
TERM_SUBFEE_TBL Term Sub Fee Table
Page 6 of 11 revised 11/9/2016
Superscript key: E = Effective-dated table; I = Institution field in table; P = Prompt table
Tuition Group Setup
Table Name Description
SEL_GROUP_TBL Selector Group Table
SEL_GROUP_CRITR Selector Group Criteria
GROUP_FEE_TBL Group Fee Table
Tuition Group Criteria Setup
Table Name Description
SEL_CRITER_TBL Group Selector Criteria
SEL_CRITR_TBL Group Selector Criteria
SEL_VALUE_TBL Selector Values Table
Waiver Setup
Table Name Description
WAIVER_CODE_TBL Waiver Code Table
WAIVER_GRP_DTL Waiver Group Detail Table
WAIVER_GRP_TBL Waiver Group Table
WAIVER_TBL Waver Table
Page 7 of 11 revised 11/9/2016
Superscript key: E = Effective-dated table; I = Institution field in table; P = Prompt table
V. Campus Community (Based on security – locked down significantly for Sandbox – CSDV6)
Person
Table Name Description
PERSON Core person data including birth and death information
PEOPLE_SRCH EMPLID join table for name and basic demographics; no contact
info
PERS_DATA_EFFDT Core person data history includes marital status and gender
PERSONAL_DATA Snapshot bio/demo data
PERSNL_FERPA_VW FERPA Personal Data View (DV6 only?)
Identification
Table Name Description
CITIZENSHIP Citizenship data
CITIZEN_STS_TBLP Citizen Status Look Up Table
CITIZEN_PSSPRT Citizenship passport data
DIVERS_ETHNIC Ethnic categories - Join with ETHNIC_GRP_TBL for
crosswalk
EXTERNAL_SYSKEY External system data (key)
EXTERNAL_SYSTEM External system data– legacy cross reference
PER_ORG_ASGN Organizational relationships
Page 8 of 11 revised 11/9/2016
Superscript key: E = Effective-dated table; I = Institution field in table; P = Prompt table
Biographic/Demographic
Table Name Description
ADDRESSESE Current Address and history (if effective dated criteria is removed)
ADDR_FERPA_VW FERPA Address View
EMAIL_ADDRESSES Email addresses
EMAIL_FERPA_VW Email FERPA view
NAMES_VWE Primary Name and history (if effective dated criteria is removed)
PERSONAL_PHONE Phone & Fax data
Student Groups
Table Name Description
STDNT_GRPS Student group data
STDNT_GRPS_HISTE Active Student groups and history (if effective dated criteria is removed)
Student Attributes
Table Name Description
STDNT_ATTR_DTL Attributes by ID
STDNT_ATTR_TBL Table of Attributes
STDNT_ATTR_VAL Table of Attribute Values
3Cs (Communications, Checklists and Comments)
Table Name Description
COMMUNICATION Communication data
PERSON_CHECKLST Checklist data
PERSON_COMMENT Comment data
Page 9 of 11 revised 11/9/2016
Superscript key: E = Effective-dated table; I = Institution field in table; P = Prompt table
Service Indicators
Table Name Description
SRVC_IND_DATA Service indicator data
SRVC_IN_RSN_TBL Service indicator reason
AUDIT_SRVC_IND Service indicator audit
VI. Course and Class Management Course data
Table Name Description
CRSE_CATALOG Course catalog; Courses like DESCRIPTION, UNIT VALUES, & GRADING
CRSE_COMPONENT Course components
CRSE_OFFER Course offerings; course data like SUBJECT, CATALOG NBR, REQUIREMENT GROUP
CRSE_EQUIV_TBL Course equivalencies
CRSE_LST_HDR_SF Course list header
CRSE_LST_DTL_SF Course list details
CRSE_TOPICS Course topics
Facilities
Table Name Description
FACILITY_TBL Table of Facility info with bldg., room and location codes
Class data
Table Name Description
CLASS_TBL Class data, Schedule of Classes, COURSE ID, CRSE_OFFER_NBR_STRM – Term, SESSION_CODE, & CLASS_SECTION
CLASS_ASSOC Class associations
CLASS_ATTENDNCE Class attendance
CLASS_COMPONENT Class components
CLASS_INSTR Class instructors
Page 10 of 11 revised 11/9/2016
Superscript key: E = Effective-dated table; I = Institution field in table; P = Prompt table
CLASS_MTG_PAT Class meeting patterns
CLASS_FEE_TBL Class Fee Table
CLASS_ATTRIBUTE Class Attribute Table
CLASS_EXAM Class Exam
RQ_GRP_TBL Requirement Groups
RQ_MAIN_TBL Requirement Table
VII. Student Records
Term Activation and History
Table Name Description
STDNT_CAREER Student career
STDNT_CAR_TERM
Student career term activation, Student cumulative units and term units, student cumulative GPA, Student Academic Level (freshmen, sophomore) for a term, Student academic load (full time, part time) for a term, Student Primary Academic Program for a term, Student eligible to enroll flag for a term
STDNT_CAR_MLSTN Student Milestone
STDNT_MLSTN Student Milestone
STDNT_SESSION Student session
TRNS_CRSE_SCH Transfer credit school
TRNS_CRSE_TERM Transfer credit course term
TRNS_OTHR_MODEL Other transfer credits model
TRNS_OTHR_TERM Other transfer credits term
TRNS_TEST_MODEL Test transfer credits model
TRNS_TEST_TERM Test transfer credits term
TRNS_CRSE_DTL Student Transfer Course Detail
TRNS_TEST_DTL Student Transfer Test Detail
Page 11 of 11 revised 11/9/2016
Superscript key: E = Effective-dated table; I = Institution field in table; P = Prompt table
Program/Plan
Table Name Description
ACAD_PROGE
Effective dated Program Statuses (Active, Disc, Dism, etc.), Student Academic Program, Program Action Reason that describes the corresponding action, Student Expected Grad Term, Student Degree Checkout Status – Parent table of ACAD_PLAN
ACAD_PLANE Student Admit Term, Child table of ACAD_PROG, Student Career Number
Student Advisor
Table Name Description
STDNT_ADVISOR Advisors
STDNT_ADVR_HIST - Student/Advisor History
Enrollment
Table Name Description
STDNT_ENRL Student enrollments (Historical student enrollment (by term). The table that holds the detail of all courses/grades taken.
STDNT_ENRL_APPT Student Appointment Table
CLASS_TBL_SE_VW View that combines student enrollment & class data; restructuring for UNITS-TAKEN field with flags for included in GPA and for earned
ENRL_REQ_HEADER Enrollment request header
ENRL_REQ_DETAIL Enrollment request detail
Honors/Awards/Graduation/Degrees
Table Name Description
ACAD_DEGR Degrees earned for an institution
ACAD_DEGR_PLAN Plan in which student has earned a degree for an institution
STDNT_AWARDS Student Awards
ACAD_DEGR_HONS Student degree honors data