PeopleSoft Campus Solution Tables

PeopleSoft Campus Solution Tables

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

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

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