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