SSR_HE_IST_FLVW(SQL View) |
Index Back |
---|---|
HESA ITT Stud Extract Fld ViewHESA 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 |