SAD_CBAP_PA_NLD

(SQL Table)
Index Back

CBAP Record

CBAP 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
Set Control Field: INSTITUTION

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
Set Control Field: INSTITUTION

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