SSR_HE_RET_TYPESSR_HE_ENTITYSSR_HE_FIELDPrompt Table: SSR_HE_FIELD_VW
SSR_HE_ENTFLDVW(SQL View) |
Index Back |
|---|---|
HESA Entity Fields View |
| SELECT A.SSR_HE_RET_TYPE , A.SSR_HE_ENTITY , A.SSR_HE_FIELD , A.SSR_HE_REP_ORD FROM PS_SSR_HE_ENT_FLDS A , PS_SSR_HE_FIELDS B ,PS_SSR_HE_ENTITIES C WHERE A.SSR_HE_FIELD=B.SSR_HE_FIELD AND B.SSR_HE_ACTIVE='Y' AND A.SSR_HE_RET_TYPE=C.SSR_HE_RET_TYPE AND A.SSR_HE_ENTITY = C.SSR_HE_ENTITY AND C.SSR_HE_ACTIVE='Y' AND %EffdtCheck(SSR_HE_ENTITIES C1, C, %CurrentDateIn) AND C.EFFDT = A.EFFDT AND A.SSR_HE_REP_ORD > 0 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SSR_HE_RET_TYPE |
Character(10) | VARCHAR2(10) NOT NULL | Return Type |
| 2 | SSR_HE_ENTITY |
Character(30) | VARCHAR2(30) NOT NULL | Entity |
| 3 | SSR_HE_FIELD |
Character(20) | VARCHAR2(20) NOT NULL |
Field
Prompt Table: SSR_HE_FIELD_VW |
| 4 | SSR_HE_REP_ORD | Number(3,0) | SMALLINT NOT NULL | Report Order |