| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SSR_HE_FIELD |
Character(20) |
VARCHAR2(20) NOT NULL |
Field
|
| 2 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 3 |
DESCR60 |
Character(60) |
VARCHAR2(60) NOT NULL |
Description
|
| 4 |
SSR_HE_DATA_TYPE |
Character(100) |
VARCHAR2(100) NOT NULL |
HESA Data Type
|
| 5 |
SSR_HE_FLD_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Field Type
DATE=Date Data Type
NBR=Number Data Type
TEXT=Text Data Type
|
| 6 |
SSR_HE_FLDTXTLNGTH |
Number(7,1) |
DECIMAL(6,1) NOT NULL |
Field Length
|
| 7 |
SSR_HE_ACTIVE |
Character(1) |
VARCHAR2(1) NOT NULL |
Active
Y/N Table Edit
Default Value: Y
|
| 8 |
SSR_HE_SOURCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Source
H=HESA Survey
I=Identify Target Population
M=Manually added
P=Import Population File
S=Seeded
U=User Entered
Default Value: U
|
| 9 |
SSR_HE_SEPARATE |
Character(3) |
VARCHAR2(3) NOT NULL |
Display Region
ENP=Entry Profile
FED=Further Education
INS=Instance
KCR=KIS Course
LOC=KIS Location
NTD=Not Displayed
OTH=Other
OVS=Aggregate Offshore
RES=Restricted
Default Value: OTH
|
| 10 |
SSR_HE_FIXED |
Character(1) |
VARCHAR2(1) NOT NULL |
Fixed
Y/N Table Edit
Default Value: N
|
| 11 |
SSR_HE_INSTTN_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Institution Flag
Y/N Table Edit
Default Value: N
|
| 12 |
SSR_HE_STUDENT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Student
Y/N Table Edit
Default Value: N
|
| 13 |
SSR_HE_INSTANC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Instance
Y/N Table Edit
Default Value: N
|
| 14 |
SSR_HE_ADVISR_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Advisor Flag
Y/N Table Edit
Default Value: N
|
| 15 |
SSR_HE_PRGM_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Program
Y/N Table Edit
Default Value: N
|
| 16 |
SSR_HE_PRGM_OFRFLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Program Offering
Y/N Table Edit
Default Value: N
|
| 17 |
SSR_HE_PRGM_OYRFLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Program Offering Year
Y/N Table Edit
Default Value: N
|
| 18 |
SSR_HE_PLAN_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Plan
Y/N Table Edit
Default Value: N
|
| 19 |
SSR_HE_PLN_OFFRFLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Plan Offering
Y/N Table Edit
Default Value: N
|
| 20 |
SSR_HE_PLN_OYR_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Plan Offering Year
Y/N Table Edit
Default Value: N
|
| 21 |
SSR_HE_SPLAN_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Subplan
Y/N Table Edit
Default Value: N
|
| 22 |
SSR_HE_SPLN_OFRFLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Sub-Plan Offering
Y/N Table Edit
Default Value: N
|
| 23 |
SSR_HE_SPLN_OYRFLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Sub-Plan Offering Year
Y/N Table Edit
Default Value: N
|
| 24 |
SSR_HE_MODULE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Module
Y/N Table Edit
Default Value: N
|