Info
Content

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. Please comment if you have any other table suggestions.

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
PS_SCC_PERSON_AUS Australian Tax File Number Data
PS_SCC_CHESSN_AUS Australian CHESSN Data

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
PS_SSR_STDENRL_AUS Australian Student Enrolment data

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
PS_SSR_ACDPRGT_AUS Australian Academic Program TAC setup
PS_SSR_ACD_PLN_AUS Australian Academic Plan 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
PS_SSR_ACADLOD_AUS Australian Academic Load 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

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 (TPCs) / 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
2 Comments
#1    Brad Radtke   Brad Radtke commented 1 month ago

A few of these person related tables may not give all of the rows that are desired from PS Query.

See Oracle Support Document 656784.1 (Queries using HR Security Views are Failing for Campus Solutions Users) can be found at: https://support.oracle.com/epmos/faces/DocumentDisplay?id=656784.1

#2    shahzad   shahzad commented 1 week ago

how can i find Employee Designation assigned from Campus ?

Back to top