SSR_HE_IST_FLVW

(SQL View)
Index Back

HESA ITT Stud Extract Fld View

HESA ITT Student Extract Fields View

SELECT A.INSTITUTION , A.SSR_HE_RET_NAME , A.SSR_HE_HUSID , A.SSR_HE_NUMHUS , A.SSR_HE_FIELD , A.SSR_HE_ACTIVE , A.EMPLID , A.SSR_HE_COURSEID , A.SSR_HE_DERIVED_VAL ,A.SSR_HE_DERIVE_STEP , A.SSR_HE_REP_VAL , A.SSR_HE_RSN_F_NL , C1.SSR_HE_REP_ORD FROM %Table(SSR_HE_ISTEX_FL) A , %Table(SSR_HE_INST_HER) B , %Table(SSR_HE_ENT_FLDS) C1 , %Table(SSR_HE_FIELDS) F WHERE C1.SSR_HE_ENTITY = 'STUDENT' AND B.SSR_HE_RET_TYPE = C1.SSR_HE_RET_TYPE AND C1.SSR_HE_FIELD = A.SSR_HE_FIELD AND A.SSR_HE_RET_NAME = B.SSR_HE_RET_NAME AND A.INSTITUTION = B.INSTITUTION AND F.SSR_HE_FIELD= A.SSR_HE_FIELD AND F.SSR_HE_ACTIVE= 'Y' AND %EffdtCheck(SSR_HE_ENT_FLDS C2, C1, %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
2 SSR_HE_RET_NAME Character(30) VARCHAR2(30) NOT NULL Return Name
3 SSR_HE_HUSID Character(17) VARCHAR2(17) NOT NULL HUSID
4 SSR_HE_NUMHUS Character(10) VARCHAR2(10) NOT NULL NUMHUS
5 SSR_HE_FIELD Character(20) VARCHAR2(20) NOT NULL Field
6 SSR_HE_ACTIVE Character(1) VARCHAR2(1) NOT NULL Active
7 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
8 SSR_HE_COURSEID Character(10) VARCHAR2(10) NOT NULL Course ID
9 SSR_HE_DERIVED_VAL Character(254) VARCHAR2(254) NOT NULL Derived Value
10 SSR_HE_DERIVE_STEP Number(3,0) SMALLINT NOT NULL Derivation Step
11 SSR_HE_REP_VAL Character(254) VARCHAR2(254) NOT NULL Reported Value
12 SSR_HE_RSN_F_NL Character(5) VARCHAR2(5) NOT NULL Reason For Null
13 SSR_HE_REP_ORD Number(3,0) SMALLINT NOT NULL Report Order