Campus Solutions Tables

The following is a list of some of the key campus solutions records grouped by functional area. This is by no means a complete list, but hopefully it proves to be a handy reference.

This is a work in progress, if you have any suggestions, please post them here.

Campus Community

Person

PS_PERSON Core person data including birth and death information
PS_PERS_DATA_EFFDT Core person data history includes martial status and gender
PS_PERSONAL_DATA Snapshot bio/demo data
PS_PER_POI_TYPE Person of Interest (POI) Type
PS_PER_POI_TRANS Person of Interest (POI) History

Identification

PS_CITIZENSHIP Citizenship data
PS_SCC_CITIZ_HIST Citizenship history
PS_CITIZEN_PSSPRT Citizenship passport data
PS_DIVERS_ETHNICITY Ethnicity data
PS_DIVERSITY Ethnicity diversity data
PS_PERS_NID National ID data
PS_EXTERNAL_SYSKEY External system data (key)
PS_EXTERNAL_SYSTEM External system data
PS_PER_ORG_ASGN Organisational relationships

Biographic/Demographic

PS_ADDRESSES Address history
PS_EMAIL_ADDRESSES Email addresses
PS_NAMES Names history
PS_PERSONAL_PHONE Phone & Fax data

3Cs (Communications, Checklists and Comments)

PS_COMMUNICATION Communication data
PS_PERSON_CHECKLST Checklist data
PS_PERSON_COMMENT Comment data
PS_VAR_DATA_[AF] Variable data. Replace [AF] with administrative function e.g. SPRG
PS_LAST_3CS_TBL Tracks the last SEQ_3C value for a student

Campus Event Planning (and Meetings)

PS_CAMPUS_EVENT Campus Event
PS_EVENT_MTG Campus Event Meeting

Service Indicators

PS_SRVC_IND_DATA Service indicator data
PS_SRVC_IN_RSN_TBL Service indicator reason
PS_AUDIT_SRVC_IND Service indicator audit

Curriculum Management

Course data

PS_CRSE_CATALOG Course catalog
PS_CRSE_COMPONENT Course components
PS_CRSE_OFFER Course offerings
PS_CRSE_EQUIV_TBL Course equivalencies
PS_CRSE_LST_HDR_SF Course list header
PS_CRSE_LST_DTL_SF Course list details
PS_CRSE_TOPICS Course topics

Class data

PS_CLASS_TBL Class data
PS_CLASS_ASSOC Class associations
PS_CLASS_ATTENDNCE Class attendance
PS_CLASS_COMPONENT Class components
PS_CLASS_INSTR Class instructors
PS_CLASS_MTG_PAT Class meeting patterns
PS_CLASS_NOTES Class notes

Records and Enrolment

Term Activation and History

PS_STDNT_CAREER Student career
PS_STDNT_CAR_TERM Student career term activation
PS_SSR_HECS_ELEC Australian-specific HECS Loan Election
PS_STDNT_SESSION Student session
PS_TRNS_CRSE_SCH Transfer credit school
PS_TRNS_CRSE_TERM Transfer credit course term
PS_TRNS_OTHR_MODEL Other transfer credits model
PS_TRNS_OTHR_TERM Other transfer credits term
PS_TRNS_TEST_MODEL Test transfer credits model
PS_TRNS_TEST_TERM Test transfer credits term

Program/Plan

PS_ACAD_PROG Student program data
PS_ACAD_PLAN Student plan data
PS_SSR_ACADPRG_AUS Australian-specific student program data

Enrolment

PS_STDNT_ENRL Student enrolments
PS_CLASS_TBL_SE_VW View that combines student enrolment & class setup data
PS_SSR_STDENRL_AUS Australian-specific student enrolment data
PS_ENRL_REQ_HEADER Enrolment request header
PS_ENRL_REQ_DETAI Enrolment request detail

Graduation/Degrees

PS_ACAD_DEGR Student degree data
PS_ACAD_DEGR_PLAN Student degree plan data
PS_ACAD_DEGR_HONS Student degree honours data

Student Groups

PS_STDNT_GRPS Student group data
PS_STDNT_GRPS_HIST Student group history

Grade Book

PS_STDNT_GRADE_DTL Student's grades detail
PS_LAM_CLASS_ACTV Class assignments information

Set Up SACR

Institution structure

PS_INSTITUTION_TBL Institution setup
PS_CAMPUS_TBL Campus setup
PS_CAMPUS_LOC_TBL Campus location setup
PS_HOME_CAMPUS_TBL Home campus setup
PS_ACAD_GROUP_TBL Academic group setup
PS_ACAD_ORG_TBL Academic organisation setup
PS_SSR_ACD_ORG_AUS Australian-specific Academic organisation setup

Academic career

PS_ACAD_CAR_TBL Academic career setup
PS_ACAD_CAR_PTRS Academic career pointers setup
PS_CATLG_CAR_TBL Academic career level setup
PS_ACAD_CAL_TABLE Academic career calendar setup
PS_HOLIDAY_TBL Holiday setup

Programs, Plans and Degrees

PS_ACAD_PROG_TBL Academic program setup
PS_ACAD_PROG_OWNER Academic program owner setup
PS_SSR_ACD_PRG_AUS Australian-specific academic program setup
PS_SSR_PRG_CD_TBL Academic program code setup
PS_ACAD_PLAN_TBL Academic plan setup
PS_DEGREE_TBL Degree setup

Term and Session

PS_TERM_TBL Term setup
PS_TERM_VAL_TBL Term Values
PS_SESSION_TBL Term session setup
PS_SESS_TIME_PEROD Session time periods

Load/Level Rules

PS_LVL_LD_RULE_TBL Academic level/load rules setup
PS_ACAD_LEVEL_TBL Academic level setup
PS_ACAD_LOAD_TBL Academic load setup
PS_ACAD_LOAD2_TBL Academic load for statistics setup
PS_SSR_LVLLOAD_AUS Australian specific load/level rules setup

Grading

PS_GRADE_TBL Grade setup
PS_GRADE_BASIS_TBL Grading basis setup
PS_GRD_BASE_CHOICE Grading basis choice setup
PS_GRADESCHEME_TBL Grading scheme setup
PS_SSR_GRADE_FLAG Grading flag setup

Security

Student Records Security

PS_SCRTY_TBL_INST Institution security
PS_SCRTY_TBL_ACAD Academic organisation security
PS_SCRTY_TBL_CAR Academic career security
PS_SCRTY_TBL_PLAN Academic plan security
PS_SCRTY_TBL_PROG Academic program security
PS_SCRTY_ADM_ACTN Admissions action security
PS_SCRTY_PROG_ACTN Program action security
PS_SCRTY_APPL_CTR Application centre security
PS_SCRTY_RECR_CTR Recruiting centre security
PS_OPR_GRP_3C_TBL 3Cs operator group security
PS_ENRL_ACCESS_GRP Enrolment access group security
PS_ENRMT_OVRD_TBL Enrolment override security by enrolment access ID
PS_SCRTY_TBL_SRVC Service indicator security
PS_SCRTY_TSCRPT Transcript type security
PS_SAD_TEST_SCTY Test ID security

Student Financials Security

PS_SEC_ISET_OPR Operator Institution set security
PS_SEC_UNITSF_OPR Operator Business unit security
PS_SEC_SETID_OPR Operator SetID security

Student Admissions/Recruiting

Applicants

PS_ADM_APP_CAR_SEQ Application career sequence (stores next available career nbr)
PS_ADM_APPL_DATA Application data
PS_ADM_APPL_PLAN Application plan
PS_ADM_APPL_PROG Application program
PS_SAD_APL_PRG_AUS Australian-specific application program data
PS_ADM_APPL_RCR_CA Recruiting category

Prospects

PS_ADM_PRSPCT_CAR Prospect career
PS_ADM_PRSPCT_PLAN Prospect plan
PS_ADM_PRSPCT_PROG Prospect program

Student Financials

Thanks to Charbin for providing these

Accounts

PS_ACCOUNT_SF Student account
PS_ITEM_SF Student account items
PS_ITEM_LINE_SF Student account item lines
PS_ITEM_XREF Student item cross reference
PS_PAYMENT_TBL Student payments
PS_QUICK_POST_TBL Quick post setup
PS_QUICK_POST_ERR Quick post errors
PS_ADM_APPL_DEP Calculated deposit fees (e.g. student housing, tuition deposit) as distinct from full charges

Billing

BI_BILL_HEADER Billing Invoice Header
BI_BILLING_LINE Billing Line
BI_BILL_MESSAGE Bill Messages
BI_STD_REQ_TBL Billing Standard Request Table
BI_BILL_ERROR Billing Errors

Credit History and Collections

PS_CREDIT_HISTORY Student Credit history
PS_COLLECTION_SF Student collections
PS_COLL_LTR_ITEM Dunning/collection letters
PS_COLLECT_EFFORT Student collections recovery effort data

Cashiering

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

SF_ACCTG_LN SF Accounting Line
SF_ACCTG_ERROR SF Quick Posting Error Table

Group Post

GROUP_CONT_INFO Control Group Info
GROUP_LINE Group Line Information/Check

Item Types

ITEM_TYPE_TBL Item Type Table
ITEM_ACCT_TYPE Valid Account Types
GL_INTERFACE General Ledger Interface

Optional Fees

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

Refunds

REFUND_HDR Refund Header
REFUND_DTL Refund Detail
REFUND_CHECK Refund Check Information
REFUND_WL Refund Work List

Term Fee Setup

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

Third Party Contracts/Deferral Contracts/Payment Plans

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 Calc

TUIT_CALC_TBL Tuition Calc Table
CALC_MESSAGES Tuition Calc Error/Warn Messages
OPT_FEE_STDNT Optional Fees by Student

Tuition Group Setup

SEL_GROUP_TBL Selector Group Table
SEL_GROUP_CRITR Selector Group Criteria
GROUP_FEE_TBL Group Fee Table

Tuition Group Criteria Setup

SEL_CRITER_TBL Group Selector Criteria
SEL_CRITR_TBL Group Selector Criteria
SEL_VALUE_TBL Selector Values Table

Waiver Setup

WAIVER_CODE_TBL Waiver Code Table
WAIVER_GRP_DTL Waiver Group Detail Table
WAIVER_GRP_TBL Waiver Group Table
WAIVER_TBL Waver Table

1098-T Reporting

SF_1098_DTL_SF SF 1098T Detail Record
SF_1098_ITEM SF 1098T Item Details

Australian Tables

Campus Community

PS_SCC_PERSON_AUS Tax File Number Data
PS_SCC_CHESSN_AUS CHESSN Data

Records and Enrolments

PS_SSR_ACADPRG_AUS Australian Student Program data
PS_SSR_STDENRL_AUS Australian Student Enrolment data

Set Up SACR

PS_SSR_LVLLOAD_AUS Australian Academic Load/Level Rules setup
PS_SSR_ACADLOD_AUS Australian Academic Load setup
PS_SSR_ACDPRGT_AUS Australian Academic Program TAC setup
PS_SSR_ACD_PLN_AUS Australian Academic Plan setup
PS_SSR_ACD_ORG_AUS Australian Academic Organisation setup

Student Admissions and Recruiting

PS_SAD_APL_PRG_AUS Australian Application Program data

Comments

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License