SAD_CBAP_PA_NLD(SQL Table) |
Index Back |
---|---|
CBAP RecordCBAP Record |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
2 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
3 | EFFDT_USED | Date(10) | DATE | Date driving 'processed' code |
4 | FILE_INPUT | Character(254) | VARCHAR2(254) NOT NULL | Test Score File Name and Path |
5 | POST_REC_SELECTION | Character(1) | VARCHAR2(1) NOT NULL |
Process Single Record
Y/N Table Edit Default Value: N |
6 | SRCH_MTCH_PST_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Search/Match/Post Process Optn
B=Search, Match and Post P=Post Only S=Search and Match Only Default Value: B |
7 | TEST_REC_NBR | Number(9,0) | DECIMAL(9) NOT NULL |
Test Type Record Nbr
Prompt Table: EDITTABLE_VW |
8 | DATA_SOURCE_RCVD | Character(3) | VARCHAR2(3) NOT NULL |
This field is used in as an operator default field in the record OPR_DEF_TBL_CS and prompt values are set to the same values as the field DATA_SOURCE and is used in the record EXT_ACAD_DATA for operator default values.
Default Value: ETS Prompt Table: XL_DATA_SRCE_VW |
9 | ADDRESS_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Address Type
Default Value: HOME Prompt Table: HCR_ADDR_TYP_I |
10 | PURGE_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Purge Option
A=All Suspense Rows M=Marked Suspense Rows Default Value: M |
11 | PURGE_MSGS_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Purge Messages
A=All Messages M=Remove Associated Messages N=Retain Associated Messages Default Value: N |
12 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTN_SCRTY |
13 | ACTION_DT | Date(10) | DATE |
Action Date
Default Value: %date |
14 | ADMIT_TERM | Character(4) | VARCHAR2(4) NOT NULL |
Admit Term
Prompt Table: TERM_VAL_TBL |
15 | ADMIT_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Admit Type
Prompt Table: ADMIT_TYPE_TBL |
16 | ACADEMIC_LEVEL | Character(3) | VARCHAR2(3) NOT NULL |
Academic Level
00=Not Set 01=First Year 02=Second Year 03=Third Year 04=Fourth Year 05=Fifth Year 06=Sixth Year 10=Freshman 20=Sophomore 30=Junior 40=Senior 50=Post-Bacc Undergraduate GR=Graduate GRA=Graduate AUS HON=Honours IE=Industrial Experience MAS=Masters P1=Professional Year 1 P2=Professional Year 2 P3=Professional Year 3 P4=Professional Year 4 PHD=PhD |
17 | ACAD_PLAN | Character(10) | VARCHAR2(10) NOT NULL |
Academic Plan
Prompt Table: ACAD_PLAN_TBL |
18 | EXT_ORG_ID | Character(11) | VARCHAR2(11) NOT NULL |
External Org ID
Prompt Table: EXT_ORG_TBL |
19 | ADM_APPL_CTR | Character(4) | VARCHAR2(4) NOT NULL |
Application Center
Prompt Table: ADM_APPLCTR_TBL |
20 | PROG_ACTION | Character(4) | VARCHAR2(4) NOT NULL |
Program Action
ACTV=Activate ADMT=Admit ADRV=Admission Revocation APPL=Application COMP=Completion of Program COND=Conditional Admit DATA=Data Change DDEF=Defer Decision DEFR=Defer Enrollment DEIN=Intention to Matriculate DENY=Deny DISC=Discontinuation DISM=Dismissal LEAV=Leave of Absence MATR=Matriculation PLNC=Plan Change PRGC=Program Change RADM=Readmit RAPP=Readmit Application RECN=Reconsideration REVK=Revoke Degree RLOA=Return from Leave of Absence SPND=Suspension TRAN=Transfer to Other Career VDIS=Voluntarily Discontinued WADM=Administrative Withdrawal WAIT=Waitlist WAOF=Waitlist Offer WAPP=Applicant Withdrawal Default Value: APPL Prompt Table: ADM_ACTION_SCTY |
21 | PROG_REASON | Character(4) | VARCHAR2(4) NOT NULL |
Action Reason
Prompt Table:
PROG_RSN_TBL
|
22 | SAD_PRA_W_CBAP_NLD | Character(4) | VARCHAR2(4) NOT NULL |
Withdrawal program action
Default Value: WADM Prompt Table: ADM_ACTION_SCTY |
23 | 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:
SAD_PROG_RSN_VW
|
24 | FILE_PATH | Character(127) | VARCHAR2(127) NOT NULL | Input/Output file path |
25 | SCC_BRINCD_NLD | Character(4) | VARCHAR2(4) NOT NULL |
BRINcode
Prompt Table: SCC_BRINCD_NLD |