SAD_CRM_FLT_ADM

(SQL View)
 Index Back

Mapping for ADM_INTERESTS

Mapping for ADM_INTERESTS.

SELECT EMPLID , ACAD_CAREER , EFFDT , SEQNUM , EXT_SUBJECT_AREA , DESCR , LS_DATA_SOURCE , PRIORITY FROM PS_ADM_INTERESTS WHERE EMPLID IN ( SELECT EMPLID FROM PS_SAD_CRM_EMPLIDS)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee 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 EFFDT Date(10) DATE Effective Date

Default Value: %date

4 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
5 EXT_SUBJECT_AREA Character(4) VARCHAR2(4) NOT NULL External Subject Area
6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
7 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
8 PRIORITY Number(3,0) SMALLINT NOT NULL Priority