SAD_SL_LOAD_PRM(SQL Table) |
Index Back |
|---|---|
Studielink Parameter RecordStudielink Load Parameters Record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SAD_RA_W_CBAP_NLD | Character(4) | VARCHAR2(4) NOT NULL |
Withdrawal action reason
ADRV=Admission Revocation DENY=Deny WADM=Administrative Withdrawal WAIT=Waitlist WAPP=Applicant Withdrawal Prompt Table: ADM_ACTION_SCTY |
| 2 | SAD_SL_W_ACTN_NLD | Character(4) | VARCHAR2(4) NOT NULL |
Records Withdrawal Action
ADRV=Admission Revocation COMP=Completion DISC=Discontinuation DISM=Dismissal LEAV=Leave of Absence SPND=Suspension VDIS=Voluntarily Discontinued WADM=Administrative Withdrawal Prompt Table: PROG_ACTN_SCTY |
| 3 | NAME_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Type of Name
Prompt Table: HCR_NM_TYP_I |
| 4 | E_ADDR_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Email Address Type.
Note: Dorm long name has been updated as Dormitory as part of PI26 updates. And, the owner id of the field is updated to CC from HR.
BUSN=Business CAMP=Campus DORM=Dormitory HOME=Home OTHR=Other |
| 5 | SAD_SL_OVERWRT_PR | Character(1) | VARCHAR2(1) NOT NULL |
Overwrite Unverified Prior Ed
Y/N Table Edit Default Value: Y |
| 6 | SAD_SL_ADMIN_NAME | Character(35) | VARCHAR2(35) NOT NULL | Administrator Name |
| 7 | SSR_SL_IDPROOF_NLD | Character(30) | VARCHAR2(30) NOT NULL | Identification Document |
| 8 | SAD_SL_GBA_NAMES | Character(1) | VARCHAR2(1) NOT NULL |
GBA Names
Y/N Table Edit Default Value: N |
| 9 | SAD_SL_VERSION | Character(1) | VARCHAR2(1) NOT NULL |
Studielink Version
1=Vers. 2.9 2=Vers. 3.0 3=Vers. 4.0 4=Vers. 5.0 Default Value: 1 |
| 10 | SAD_SL_RE_ENROL | Character(1) | VARCHAR2(1) NOT NULL |
Re- Enrolment
Y/N Table Edit Default Value: Y |
| 11 | SAD_SL_IBG_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
IBG status
Y/N Table Edit Default Value: Y |
| 12 | SAD_SL_WDR_RQST | Character(1) | VARCHAR2(1) NOT NULL |
Re- Enrolment
Y/N Table Edit Default Value: Y |
| 13 | SAD_SL_ADMN_SUSP | Character(1) | VARCHAR2(1) NOT NULL |
Re- Enrolment
Y/N Table Edit Default Value: Y |
| 14 | SAD_SL_19_SEND | Character(1) | VARCHAR2(1) NOT NULL |
Send Message 19 automatically
Y/N Table Edit Default Value: Y |
| 15 | SAD_SL_19_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Payment of Fees
N=Do Not Send Y=Send Y/N Table Edit Default Value: Y |
| 16 | SAD_SL_19_STAT_IN | Character(1) | VARCHAR2(1) NOT NULL |
Payment of Fees(19) Inbound
Y/N Table Edit Default Value: Y |
| 17 | SAD_SL_20_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Cost of Fees
N=Do Not Send Y=Send Y/N Table Edit Default Value: Y |
| 18 | SAD_SL_47_DEBIT | Character(1) | VARCHAR2(1) NOT NULL |
Electronic Direct Debit (47)
Y/N Table Edit Default Value: Y |
| 19 | SSR_PRG_ACTION_NLD | Character(4) | VARCHAR2(4) NOT NULL |
Progr Action Higher Education
CENR=Change Enrollment DATA=Data Change DSAC=Departure Accepted DSNA=Departure Not Accepted ENRL=Enrollment EXAM=Examination MATR=Matriculation NRNR=No Re-Enrollment PAYM=Payment RENR=Re-Enrollment SLCN=Studielink Conversion |
| 20 | SSR_PRG_ACT31B_NLD | Character(4) | VARCHAR2(4) NOT NULL |
Progr Action Higher Education for 31B message
CENR=Change Enrollment DATA=Data Change DSAC=Departure Accepted DSNA=Departure Not Accepted ENRL=Enrollment EXAM=Examination MATR=Matriculation NRNR=No Re-Enrollment PAYM=Payment RENR=Re-Enrollment SLCN=Studielink Conversion |
| 21 | SSR_SLC_ACT31B_NLD | Character(4) | VARCHAR2(4) NOT NULL |
Progr Action Higher Education for 31B message
CENR=Change Enrollment DATA=Data Change DSAC=Departure Accepted DSNA=Departure Not Accepted ENRL=Enrollment EXAM=Examination MATR=Matriculation NRNR=No Re-Enrollment PAYM=Payment RENR=Re-Enrollment SLCN=Studielink Conversion |
| 22 | SSR_PRG_ACT31C_NLD | Character(4) | VARCHAR2(4) NOT NULL |
Progr Action Higher Education for 31C message
CENR=Change Enrollment DATA=Data Change DSAC=Departure Accepted DSNA=Departure Not Accepted ENRL=Enrollment EXAM=Examination MATR=Matriculation NRNR=No Re-Enrollment PAYM=Payment RENR=Re-Enrollment SLCN=Studielink Conversion |
| 23 | SSR_SLC_ACT31C_NLD | Character(4) | VARCHAR2(4) NOT NULL |
Progr Action Higher Education for 31C message
CENR=Change Enrollment DATA=Data Change DSAC=Departure Accepted DSNA=Departure Not Accepted ENRL=Enrollment EXAM=Examination MATR=Matriculation NRNR=No Re-Enrollment PAYM=Payment RENR=Re-Enrollment SLCN=Studielink Conversion |
| 24 | SAD_SL_PAY_CRT_ROW | Character(1) | VARCHAR2(1) NOT NULL |
Create Payment Row
Y/N Table Edit Default Value: Y |
| 25 | SAD_SL_FADDR_PB | Character(1) | VARCHAR2(1) NOT NULL |
Foreign Address
Y/N Table Edit Default Value: Y |
| 26 | SAD_SL_04_STAT | Character(1) | VARCHAR2(1) NOT NULL |
GBA Verification
N=Do Not Send Y=Send Y/N Table Edit Default Value: Y |
| 27 | SAD_SL_06_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Address Change
N=Do Not Send Y=Send Y/N Table Edit Default Value: Y |
| 28 | SAD_SL_10_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Prior Education
N=Do Not Send Y=Send Y/N Table Edit Default Value: Y |
| 29 | SAD_SL_31A_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Receipt of Application
N=Do Not Send Y=Send Y/N Table Edit Default Value: Y |
| 30 | SAD_SL_31B_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Confirm Enrollment
N=Do Not Send Y=Send Y/N Table Edit Default Value: Y |
| 31 | SAD_SL_31C_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Confirm Re-enrollment
N=Do Not Send Y=Send Y/N Table Edit Default Value: Y |
| 32 | SAD_SL_31D_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Discontinuation Not Allowed
N=Do Not Send Y=Send Y/N Table Edit Default Value: Y |
| 33 | SAD_SL_31E_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Discontinuation Allowed
N=Do Not Send Y=Send Y/N Table Edit Default Value: Y |
| 34 | SAD_SL_31F_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Cancellation Confirmed
N=Do Not Send Y=Send Y/N Table Edit Default Value: Y |
| 35 | SAD_SL_31G_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Withdrawal Confirmed
N=Do Not Send Y=Send Y/N Table Edit Default Value: Y |
| 36 | SAD_SL_31H_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Non First Year
N=Do Not Send Y=Send Y/N Table Edit Default Value: Y |
| 37 | SAD_SL_31I_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Professional Duties
N=Do Not Send Y=Send Y/N Table Edit Default Value: Y |
| 38 | SAD_SL_31J_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Language Test
N=Do Not Send Y=Send Y/N Table Edit Default Value: Y |
| 39 | SAD_SL_31K_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Prior Ed Deficiency
N=Do Not Send Y=Send Y/N Table Edit Default Value: Y |
| 40 | SAD_SL_31L_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Admission Delete
N=Do Not Send Y=Send Y/N Table Edit Default Value: Y |
| 41 | SAD_SL_31M_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Re-enroll Delete
N=Do Not Send Y=Send Y/N Table Edit Default Value: Y |
| 42 | SAD_SL_31N_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Lot Drawing Result
N=Do Not Send Y=Send Y/N Table Edit Default Value: Y |
| 43 | SAD_SL_31O_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Study Progress
N=Do Not Send Y=Send Y/N Table Edit Default Value: Y |
| 44 | SAD_SL_31P_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Profession Requirements
N=Do Not Send Y=Send Y/N Table Edit Default Value: Y |
| 45 | SAD_SL_31Q_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Confirmation Receipt (31Q)
N=Do Not Send Y=Send Y/N Table Edit Default Value: Y |
| 46 | SAD_SL_37_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Death of Student
N=Do Not Send Y=Send Y/N Table Edit Default Value: Y |
| 47 | SAD_SL_48_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Correction end enroll (48)
Y/N Table Edit Default Value: Y |
| 48 | SAD_SL_05_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Personal Data (05)
N=Do not Send Y=Send |
| 49 | SAD_SL_07_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Update Prior Education (07)
N=Do not Send Y=Send |
| 50 | SAD_SL_08_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Update Bank Account (08)
N=Do Not Send Y=Send |
| 51 | SAD_SL_04_STAT_I | Character(1) | VARCHAR2(1) NOT NULL |
GBA Verification
N=Do Not Send Y=Send |
| 52 | SAD_SL_06_STAT_I | Character(1) | VARCHAR2(1) NOT NULL |
Address Change
N=Do Not Send Y=Send |
| 53 | SAD_SL_10_STAT_I | Character(1) | VARCHAR2(1) NOT NULL |
Prior Education
N=Do Not Send Y=Send |
| 54 | SAD_SL_10_SUB_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Send Prior Ed Subjects
Y/N Table Edit Default Value: N |
| 55 | SAD_SL_10SUBI_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Process Prior Ed Subjects
Y/N Table Edit |