SAD_APL_CAF_STG

(SQL Table)
Index Back

Application Data

Stage and Load staging record for ADM_APPL_DATA

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SCC_TEMP_ID Number(16,0) DECIMAL(16) NOT NULL Temp Constituent ID
2 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

Prompt Table: STDNT_CAREER

3 STDNT_CAR_NBR Number(3,0) SMALLINT NOT NULL Student Career Nbr
4 ADM_APPL_NBR Character(8) VARCHAR2(8) NOT NULL Application Nbr
5 SCC_CAF_ATTR_SEQ Number(4,0) SMALLINT NOT NULL Attribute Sequence
6 SCC_CAF_ATTRIB_NM Character(20) VARCHAR2(20) NOT NULL Common Attribute

Prompt Table: %EDITTABLE18

7 SCC_CAF_ATTR_VAL Character(20) VARCHAR2(20) NOT NULL Attribute Value
8 SCC_CAF_ATTR_NVAL Number(32,11) DECIMAL(31,11) NOT NULL Numeric Value
9 SCC_CAF_ATTR_DVAL Date(10) DATE Date Value
10 SCC_CAF_ATTR_TVAL Character(50) VARCHAR2(50) NOT NULL Text Value
11 SCC_CAF_ATTR_TIME Time(15) TIMESTAMP Time Value
12 SCC_CAF_ATTR_YNO Character(1) VARCHAR2(1) NOT NULL Yes/No Value

Y/N Table Edit

13 SCC_CAF_ATTR_LVAL Long Character CLOB Long Text Value
14 SSR_SHOW_STU_SS Character(1) VARCHAR2(1) NOT NULL Show in Student SS

Y/N Table Edit

Default Value: Y

15 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
16 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
17 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
18 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time