SAD_UC_I_IVPREP

(SQL Table)
 Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Prompt Table: INSTITUTION_TBL

2 SAD_UC_APPCODE Character(10) VARCHAR2(10) NOT NULL Application Code
3 SAD_UC_PERS_ID Character(10) VARCHAR2(10) NOT NULL Personalid - Unique personal identifier
4 SAD_UC_PREPACTNO Number(2,0) SMALLINT NOT NULL Activity Number
5 SAD_UC_TIMESTAMP DateTime(26) TIMESTAMP Timestamp
6 SAD_UC_STARTDATE DateTime(26) TIMESTAMP Start Date
7 SAD_UC_DURATION Number(2,0) SMALLINT NOT NULL Duration in Days
8 SAD_UC_INSTCODE Character(50) VARCHAR2(50) NOT NULL Abbrev Institution Name
9 SAD_UC_SPONSOR Character(3) VARCHAR2(3) NOT NULL Sponsor Code
10 SAD_UC_SCHOOLYEAR Character(10) VARCHAR2(10) NOT NULL School Year Code
11 SAD_UC_IMP_STATUS Character(1) VARCHAR2(1) NOT NULL Import Status
E=Error (E)
I=Imported (I)
N=New (N)
P=Pending (P)
R=Pending (R)
T=Error (T)
12 SAD_UC_HEAT_CODE Character(3) VARCHAR2(3) NOT NULL HE Activity Type
13 SAD_UC_ACT_NAME Character(100) VARCHAR2(100) NOT NULL Activity Name
14 SAD_UC_ENDDATE DateTime(26) TIMESTAMP End Date