SAD_CBAPTMP_AET (SQL Table)	Index Back
CBAP State record temp This state record contains temporary variables used during the posting process.

SAD_CBAPTMP_AET

(SQL Table)

CBAP State record temp

This state record contains temporary variables used during the posting process.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 ADM_APPL_NBR Character(8) VARCHAR2(8) NOT NULL Application Nbr

3 GRADUATION_DT Date(10) DATE Graduation Date

4 SUBJECT_NEW Character(1) VARCHAR2(1) NOT NULL New Subject

5 SSR_FORM_STUDY_NLD Character(4) VARCHAR2(4) NOT NULL Form of Study Higher Education
A=Auditor
D=Participant
E=Extraneus
S=Student
T=Coop/Dual

6 SSR_ACAD_LEVEL_NLD Character(4) VARCHAR2(4) NOT NULL Academ. Level Higher Education
A=Associate Degree
B=Bachelor
D=Propaedeutic Bachelor
H=Main
I=Initial Phase
K=Candidate
L=University teacher education
M=Master
P=Propaedeutic Phase
Q=Post-Initial
T=Interim Doctoral Exam
V=Continuation Phase
W=Continuing study

7 SSR_FUNDING_CD_NLD Character(1) VARCHAR2(1) NOT NULL Funding Applies

8 EFFDT Date(10) DATE Effective Date
Default Value: %date

9 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence

10 CHECKLIST_SEQ Number(6,0) INTEGER NOT NULL Checklist Sequence

11 CHKLST_ITEM_CD Character(6) VARCHAR2(6) NOT NULL Checklist Item Code

12 COMM_KEY Character(8) VARCHAR2(8) NOT NULL Communication Speed Key

13 CHECKLIST_DTTM DateTime(26) TIMESTAMP Checklist Date Time

14 ACAD_CAREER Character(4) VARCHAR2(4) NOT NULL Academic Career
BAC=Bachelor (NLD)
BBL=Vocational Coaching (NLD)
BOL=Vocational Training (NLD)
BUSN=Graduate Business
CNED=Continuing Education
CRED=Semester Credit
EDU=Education (NLD)
EXED=Extended Education
GRAD=Graduate
LAW=Law
MEDS=Medical School
NONA=Non Award
PGRD=Postgraduate
RSCH=Research
TECH=Technical
UENG=Undergraduate Engineering
UGRD=Undergraduate
VAVO=Advanced General Educ. (NLD)
VETM=Veterinary Medicine

15 STDNT_CAR_NBR Number(3,0) SMALLINT NOT NULL Student Career Nbr

16 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
Prompt Table: INST_CAR_SCTY

17 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program
Prompt Table: ACAD_PROG_SCTY

18 PROG_STATUS Character(4) VARCHAR2(4) NOT NULL Academic Program Status
AC=Active in Program
AD=Admitted
AP=Applicant
CM=Completed Program
CN=Cancelled
DC=Discontinued
DE=Deceased
DM=Dismissed
LA=Leave of Absence
PM=Prematriculant
SP=Suspended
WT=Waitlisted

19 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
Prompt Table: PROG_ACTN_SCTY

20 ACTION_DT Date(10) DATE NOT NULL Action Date
Default Value: %date

21 PROG_REASON Character(4) VARCHAR2(4) NOT NULL Action Reason
Prompt Table: PROG_RSN_TBL

22 ADMIT_TERM Character(4) VARCHAR2(4) NOT NULL Admit Term
Prompt Table: TERM_TBL

23 EXP_GRAD_TERM Character(4) VARCHAR2(4) NOT NULL Expected Graduation Term
Prompt Table: TERM_TBL

24 REQ_TERM Character(4) VARCHAR2(4) NOT NULL Requirement Term
Default Value: ACAD_PROG.ADMIT_TERM
Prompt Table: TERM_TBL

25 ACAD_LOAD_APPR Character(1) VARCHAR2(1) NOT NULL Approved Academic Load
B=Vocational Coaching (NLD)
D=Dual (NLD)
E=Part-time Vocational Tr (NLD)
F=Full-Time
O=Vocational Training (NLD)
P=Part-Time
Default Value: F

26 CAMPUS Character(5) VARCHAR2(5) NOT NULL Campus
Prompt Table: HOME_CAMPUS_VW

27 DEGR_CHKOUT_STAT Character(2) VARCHAR2(2) NOT NULL Degree Checkout Status
AG=Applied for Graduation
AP=Approved
AW=Degree Awarded
DN=Denied
EG=Eligible for Graduation
IR=Program in Review
PN=Needs to Finish Pending Work
WD=Withdrawn

28 COMPLETION_TERM Character(4) VARCHAR2(4) NOT NULL Completion Term
Prompt Table: TERM_TBL

29 ACAD_PROG_DUAL Character(5) VARCHAR2(5) NOT NULL Dual Academic Program
Prompt Table: ACAD_PROG_TBL

30 JOINT_PROG_APPR Character(1) VARCHAR2(1) NOT NULL Joint Program Approved
Y/N Table Edit
Default Value: N

31 APPL_PROG_NBR Number(3,0) SMALLINT NOT NULL Application Program Nbr

32 DATA_FROM_ADM_APPL Character(1) VARCHAR2(1) NOT NULL Data from Admissions Appl
Y/N Table Edit
Default Value: N

33 ALLOW_DELETE Character(1) VARCHAR2(1) NOT NULL Allow Delete

34 ACAD_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan
Prompt Table: ACAD_PLAN_TBLVW

35 DECLARE_DT Date(10) DATE NOT NULL Declare Date

36 PLAN_SEQUENCE Number(2,0) SMALLINT NOT NULL Plan Sequence

37 STDNT_DEGR Character(2) VARCHAR2(2) NOT NULL Student Degree Nbr

38 ADVIS_STATUS Character(4) VARCHAR2(4) NOT NULL This field is used to track if the current program, plan, or subplan is to be included in an academic advisement report.
INCL=Include
NINC=Do Not Include
OPT=Optional
Default Value: INCL

39 EFFDT_OLD Date(10) DATE Old Effective Date

40 EFFSEQ_WRK Number(3,0) SMALLINT NOT NULL Effective Sequence

41 ALLOW_CREATE Character(1) VARCHAR2(1) NOT NULL Allow Create

42 SSR_RS_CANDIT_NBR Character(12) VARCHAR2(12) NOT NULL Last Candidate Number

43 SSR_APT_INSTANCE Number(3,0) SMALLINT NOT NULL Academic Progress Tracker Instance Number

44 SSR_YR_OF_PROG Character(4) VARCHAR2(4) NOT NULL Year of Program
00=Not Set
01=01 - First Year
02=02 - Second Year
03=03 - Third Year
04=04 - Fourth Year
05=05 - Fifth Year
06=06 - Sixth Year
Default Value: 01

45 SSR_SHIFT Character(12) VARCHAR2(12) NOT NULL Academic Shift

46 SSR_COHORT_ID Character(12) VARCHAR2(12) NOT NULL Cohort Tag

47 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By

48 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created

49 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By

50 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	ADM_APPL_NBR	Character(8)	VARCHAR2(8) NOT NULL	Application Nbr
3	GRADUATION_DT	Date(10)	DATE	Graduation Date
4	SUBJECT_NEW	Character(1)	VARCHAR2(1) NOT NULL	New Subject
5	SSR_FORM_STUDY_NLD	Character(4)	VARCHAR2(4) NOT NULL	Form of Study Higher Education A=Auditor D=Participant E=Extraneus S=Student T=Coop/Dual
6	SSR_ACAD_LEVEL_NLD	Character(4)	VARCHAR2(4) NOT NULL	Academ. Level Higher Education A=Associate Degree B=Bachelor D=Propaedeutic Bachelor H=Main I=Initial Phase K=Candidate L=University teacher education M=Master P=Propaedeutic Phase Q=Post-Initial T=Interim Doctoral Exam V=Continuation Phase W=Continuing study
7	SSR_FUNDING_CD_NLD	Character(1)	VARCHAR2(1) NOT NULL	Funding Applies
8	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
9	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
10	CHECKLIST_SEQ	Number(6,0)	INTEGER NOT NULL	Checklist Sequence
11	CHKLST_ITEM_CD	Character(6)	VARCHAR2(6) NOT NULL	Checklist Item Code
12	COMM_KEY	Character(8)	VARCHAR2(8) NOT NULL	Communication Speed Key
13	CHECKLIST_DTTM	DateTime(26)	TIMESTAMP	Checklist Date Time
14	ACAD_CAREER	Character(4)	VARCHAR2(4) NOT NULL	Academic Career BAC=Bachelor (NLD) BBL=Vocational Coaching (NLD) BOL=Vocational Training (NLD) BUSN=Graduate Business CNED=Continuing Education CRED=Semester Credit EDU=Education (NLD) EXED=Extended Education GRAD=Graduate LAW=Law MEDS=Medical School NONA=Non Award PGRD=Postgraduate RSCH=Research TECH=Technical UENG=Undergraduate Engineering UGRD=Undergraduate VAVO=Advanced General Educ. (NLD) VETM=Veterinary Medicine
15	STDNT_CAR_NBR	Number(3,0)	SMALLINT NOT NULL	Student Career Nbr
16	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution Prompt Table: INST_CAR_SCTY
17	ACAD_PROG	Character(5)	VARCHAR2(5) NOT NULL	Academic Program Prompt Table: ACAD_PROG_SCTY
18	PROG_STATUS	Character(4)	VARCHAR2(4) NOT NULL	Academic Program Status AC=Active in Program AD=Admitted AP=Applicant CM=Completed Program CN=Cancelled DC=Discontinued DE=Deceased DM=Dismissed LA=Leave of Absence PM=Prematriculant SP=Suspended WT=Waitlisted
19	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 Prompt Table: PROG_ACTN_SCTY
20	ACTION_DT	Date(10)	DATE NOT NULL	Action Date Default Value: %date
21	PROG_REASON	Character(4)	VARCHAR2(4) NOT NULL	Action Reason Prompt Table: PROG_RSN_TBL
22	ADMIT_TERM	Character(4)	VARCHAR2(4) NOT NULL	Admit Term Prompt Table: TERM_TBL
23	EXP_GRAD_TERM	Character(4)	VARCHAR2(4) NOT NULL	Expected Graduation Term Prompt Table: TERM_TBL
24	REQ_TERM	Character(4)	VARCHAR2(4) NOT NULL	Requirement Term Default Value: ACAD_PROG.ADMIT_TERM Prompt Table: TERM_TBL
25	ACAD_LOAD_APPR	Character(1)	VARCHAR2(1) NOT NULL	Approved Academic Load B=Vocational Coaching (NLD) D=Dual (NLD) E=Part-time Vocational Tr (NLD) F=Full-Time O=Vocational Training (NLD) P=Part-Time Default Value: F
26	CAMPUS	Character(5)	VARCHAR2(5) NOT NULL	Campus Prompt Table: HOME_CAMPUS_VW
27	DEGR_CHKOUT_STAT	Character(2)	VARCHAR2(2) NOT NULL	Degree Checkout Status AG=Applied for Graduation AP=Approved AW=Degree Awarded DN=Denied EG=Eligible for Graduation IR=Program in Review PN=Needs to Finish Pending Work WD=Withdrawn
28	COMPLETION_TERM	Character(4)	VARCHAR2(4) NOT NULL	Completion Term Prompt Table: TERM_TBL
29	ACAD_PROG_DUAL	Character(5)	VARCHAR2(5) NOT NULL	Dual Academic Program Prompt Table: ACAD_PROG_TBL
30	JOINT_PROG_APPR	Character(1)	VARCHAR2(1) NOT NULL	Joint Program Approved Y/N Table Edit Default Value: N
31	APPL_PROG_NBR	Number(3,0)	SMALLINT NOT NULL	Application Program Nbr
32	DATA_FROM_ADM_APPL	Character(1)	VARCHAR2(1) NOT NULL	Data from Admissions Appl Y/N Table Edit Default Value: N
33	ALLOW_DELETE	Character(1)	VARCHAR2(1) NOT NULL	Allow Delete
34	ACAD_PLAN	Character(10)	VARCHAR2(10) NOT NULL	Academic Plan Prompt Table: ACAD_PLAN_TBLVW
35	DECLARE_DT	Date(10)	DATE NOT NULL	Declare Date
36	PLAN_SEQUENCE	Number(2,0)	SMALLINT NOT NULL	Plan Sequence
37	STDNT_DEGR	Character(2)	VARCHAR2(2) NOT NULL	Student Degree Nbr
38	ADVIS_STATUS	Character(4)	VARCHAR2(4) NOT NULL	This field is used to track if the current program, plan, or subplan is to be included in an academic advisement report. INCL=Include NINC=Do Not Include OPT=Optional Default Value: INCL
39	EFFDT_OLD	Date(10)	DATE	Old Effective Date
40	EFFSEQ_WRK	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
41	ALLOW_CREATE	Character(1)	VARCHAR2(1) NOT NULL	Allow Create
42	SSR_RS_CANDIT_NBR	Character(12)	VARCHAR2(12) NOT NULL	Last Candidate Number
43	SSR_APT_INSTANCE	Number(3,0)	SMALLINT NOT NULL	Academic Progress Tracker Instance Number
44	SSR_YR_OF_PROG	Character(4)	VARCHAR2(4) NOT NULL	Year of Program 00=Not Set 01=01 - First Year 02=02 - Second Year 03=03 - Third Year 04=04 - Fourth Year 05=05 - Fifth Year 06=06 - Sixth Year Default Value: 01
45	SSR_SHIFT	Character(12)	VARCHAR2(12) NOT NULL	Academic Shift
46	SSR_COHORT_ID	Character(12)	VARCHAR2(12) NOT NULL	Cohort Tag
47	SCC_ROW_ADD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Created By
48	SCC_ROW_ADD_DTTM	DateTime(26)	TIMESTAMP	Created
49	SCC_ROW_UPD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Updated By
50	SCC_ROW_UPD_DTTM	DateTime(26)	TIMESTAMP	Last Update Date/Time