Campus Solutions Tables

1.    Setup SACR

1.1  Academic structure

Record Name
Description
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

1.2  Academic career

Record Name
Description
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

1.3 Programs, Plans and Degrees

Record Name
Description
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


1.4 Term and Session

Record Name
Description
PS_TERM_TBL
Term setup
PS_TERM_VAL_TBL
Term Values
PS_SESSION_TBL
Term session setup
PS_SESS_TIME_PEROD
Session time periods

1.5 Load/Level Rules

Record Name
Description
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

1.6  Grading

Record Name
Description
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

2. Campus Community

2.1  Person Data

Record Name
Description
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

2.2 Identification Data

Record Name
Description
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

2.3 Biographic/Demographic

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

2.4  3Cs (Communications, Checklists and Comments)

Record Name
Description
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

2.5 Campus Event Planning (and Meetings)

Record Name
Description
PS_CAMPUS_EVENT
Campus Event
PS_EVENT_MTG
Campus Event Meeting

2.6 Service Indicators

Record Name
Description
PS_SRVC_IND_DATA
Service indicator data
PS_SRVC_IN_RSN_TBL
Service indicator reason
PS_AUDIT_SRVC_IND
Service indicator audit



3.    Curriculum Management

3.1 Course data

Record Name
Description
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

3.2 Class data

Record Name
Description
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


 

4.    Student Admissions/Recruiting

4.1 Applicants

Record Name
Description
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

4.2 Prospects

Record Name
Description
PS_ADM_PRSPCT_CAR
Prospect career
PS_ADM_PRSPCT_PLAN
Prospect plan
PS_ADM_PRSPCT_PROG
Prospect program



5.    Security

5.1 Student Records Security

Record Name
Description
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

 

 

5.2 Student Financials Security

Record Name
Description
PS_SEC_ISET_OPR
Operator Institution set security
PS_SEC_UNITSF_OPR
Operator Business unit security
PS_SEC_SETID_OPR
Operator SetID security

No comments:

Post a Comment