SSR_HE_RET_TYPESSR_HE_ENTITYEFFDTDefault Value: %date
SSR_HE_FIELDPrompt Table: SSR_HE_FIELD_VW
Prompt Table: SSR_HE_FLDRV_VW
Y/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: Y
Y/N Table Edit
Default Value: Y
K=Key
R=Required
SSR_HE_ENT_FLDS(SQL Table) |
Index Back |
|---|---|
HESA Entity Fields |
| # | 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 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | SSR_HE_FIELD |
Character(20) | VARCHAR2(20) NOT NULL |
Field
Prompt Table: SSR_HE_FIELD_VW |
| 5 | SSR_HE_REP_ORD | Number(3,0) | SMALLINT NOT NULL | Report Order |
| 6 | SSR_HE_XML_TAG | Character(40) | VARCHAR2(40) NOT NULL | XML Tag |
| 7 | SSR_HE_DRV_RULE | Character(40) | VARCHAR2(40) NOT NULL |
This field is the Rule ID for rules used in the Rules Engine
Prompt Table: SSR_HE_FLDRV_VW |
| 8 | SSR_HE_INCLUDE | Character(1) | VARCHAR2(1) NOT NULL |
Include for all entities
Y/N Table Edit Default Value: N |
| 9 | SSR_HE_ALLOW_DERV | Character(1) | VARCHAR2(1) NOT NULL |
Allow Field Derivation
Y/N Table Edit Default Value: Y |
| 10 | SSR_HE_ALLOW_STEPS | Character(1) | VARCHAR2(1) NOT NULL |
Allow Field Derivation Steps
Y/N Table Edit Default Value: Y |
| 11 | SSR_HE_FTYPE | Character(1) | VARCHAR2(1) NOT NULL |
Type
K=Key R=Required |