SSR_HE_RET_TYPESSR_HE_ENTITYEFFDTDefault Value: %date
SSR_HE_FIELDPrompt Table: SSR_HE_FIELD_VW
SSR_HE_STEP_NUMPrompt Table: SSR_HE_RULE_VW
SSR_HE_ENT_FDRV(SQL Table) |
Index Back |
|---|---|
HESA Entity Field DerivationHESA Entity Field Derivation |
| # | 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_STEP_NUM |
Number(3,0) | SMALLINT NOT NULL | Step Number |
| 6 | 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_RULE_VW |