HR_EH_AG_TMPL_IDPrompt Table: HR_EH_AGTMP_VW
Prompt Table: HR_EH_EFFDT_VW
Default Value: N
HR_EH_ACT_GUIDE(SQL Table) |
Index Back |
|---|---|
Config Header - Activity GuideConfigurable Header ID - Activity Guide Mapping Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HR_EH_AG_TMPL_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Activity Guide Composer Template ID
Prompt Table: HR_EH_AGTMP_VW |
| 2 | HR_EH_HEADER_ID | Character(15) | VARCHAR2(15) NOT NULL |
Mouse Over Data: Mouse Over ID
Prompt Table: HR_EH_EFFDT_VW |
| 3 | SYSTEM_DATA_FLG | Character(1) | VARCHAR2(1) NOT NULL |
This Y/ N field is used to identify which rows in a table are considered SYSTEM DATA.
Default Value: N |