SAD_CRM_FLT_EXT

(SQL View)
 Index Back

Mapping for EXTRACUR_ACTVTY

Mapping for EXTRACUR_ACTVTY.

SELECT EMPLID , INTERNAL_EXTERNAL , EXTRA_ACTIVITY , DESCR , START_DT , INSTITUTION , ACAD_CAREER , STRM , EXTRA_ACTVTY_TYPE , OFFICE_HELD , END_DT , INTEREST_FLAG , YEARS_VARSITY , NINTH_GRADE , TENTH_GRADE , ELEVENTH_GRADE , TWELFTH_GRADE , POSTSECONDARY , TIME_UNIT_DEFINE1 , TIME_UNIT_DEFINE2 , TIME_UNIT1 , TIME_UNIT2 , DESCRLONG FROM PS_EXTRACUR_ACTVTY 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 INTERNAL_EXTERNAL Character(1) VARCHAR2(1) NOT NULL Internal/External
E=External
I=Internal
3 EXTRA_ACTIVITY Character(6) VARCHAR2(6) NOT NULL Extracurricular Activity
4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
5 START_DT Date(10) DATE Start Date
6 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
7 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
8 STRM Character(4) VARCHAR2(4) NOT NULL Term
9 EXTRA_ACTVTY_TYPE Character(4) VARCHAR2(4) NOT NULL Activity Type
ATHL=Athletics
CLUB=Club
EMPL=Employment
GOVT=Student Government
MUSC=Music
OTHR=Other
PUBL=Publications
THEA=Theater
VOLN=Volunteer
10 OFFICE_HELD Character(4) VARCHAR2(4) NOT NULL Office Held
CAPT=Captain
EIC=Editor-In-Chief
PRES=President
TRES=Treasurer
VP=Vice President
11 END_DT Date(10) DATE end date
12 INTEREST_FLAG Character(1) VARCHAR2(1) NOT NULL Participation Interest flag
13 YEARS_VARSITY Number(1,0) SMALLINT NOT NULL Years Varsity
14 NINTH_GRADE Character(1) VARCHAR2(1) NOT NULL Ninth Grade
15 TENTH_GRADE Character(1) VARCHAR2(1) NOT NULL Tenth Grade
16 ELEVENTH_GRADE Character(1) VARCHAR2(1) NOT NULL Eleventh Grade
17 TWELFTH_GRADE Character(1) VARCHAR2(1) NOT NULL Twelfth Grade
18 POSTSECONDARY Character(1) VARCHAR2(1) NOT NULL Postsecondary
19 TIME_UNIT_DEFINE1 Character(2) VARCHAR2(2) NOT NULL Time Unit Definition
DM=Days per Month
DW=Days per Week
DY=Days per Year
HD=Hours per Day
HM=Hours per Month
HW=Hours per Week
HY=Hours per Year
MY=Months per Year
WY=Weeks per Year
20 TIME_UNIT_DEFINE2 Character(2) VARCHAR2(2) NOT NULL Time Unit Definition
DM=Days per Month
DW=Days per Week
DY=Days per Year
HD=Hours per Day
HM=Hours per Month
HW=Hours per Week
HY=Hours per Year
MY=Months per Year
WY=Weeks per Year
21 TIME_UNIT1 Number(8,2) DECIMAL(7,2) NOT NULL Time Unit 1
22 TIME_UNIT2 Number(8,2) DECIMAL(7,2) NOT NULL Time Unit 2
23 DESCRLONG Long Character CLOB Long Description