SCC_STG_ADMINT(SQL Table) |
Index Back |
---|---|
Academic InterestsStaging table for Academic Interests |
# | 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 |
3 | SEQNUM | Number(3,0) | SMALLINT NOT NULL | Sequence Number |
4 | EXT_SUBJECT_AREA | Character(4) | VARCHAR2(4) NOT NULL |
External Subject Area
Prompt Table: ACAD_INTERST_VW |
5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
6 | LS_DATA_SOURCE | Character(3) | VARCHAR2(3) NOT NULL |
Data Source
A8=TEAS Degree Information AAD=AADSAS ACT=American College Testing AE=Ad-Hoc Employee AMC=AMCAS AO=Ad-Hoc Organizational E=Extract ETS=Educational Testing Service GH=OLSAS Last Secondary-G2 LSD=LSDAS PI=Prev/Post Secondary Info RS=OLSAS Postsecondary Info SCH=School SLF=Self-Reported Information WWW=World Wide Web Default Value: SLF |
7 | PRIORITY | Number(3,0) | SMALLINT NOT NULL | Priority |
8 | SCC_ROW_ADD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Created By |
9 | SCC_ROW_ADD_DTTM | DateTime(26) | TIMESTAMP | Created |
10 | SCC_ROW_UPD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Updated By |
11 | SCC_ROW_UPD_DTTM | DateTime(26) | TIMESTAMP | Last Update Date/Time |