HR_EH_AG_TMPL_IDEFFDTDefault Value: %date
HR_EH_AGTMP_VW(SQL View) |
Index Back |
|---|---|
AG Template ViewConfigurable Header - Activity Guide Template Prompt |
| SELECT TMPL.AGC_TEMPLATE_ID, TMPL.EFFDT, TMPL.DESCR100 FROM PS_AGC_TMPL_TBL TMPL WHERE TMPL.EFFDT = ( SELECT MAX(TMPL_ED.EFFDT) FROM PS_AGC_TMPL_TBL TMPL_ED WHERE TMPL_ED.AGC_TEMPLATE_ID = TMPL.AGC_TEMPLATE_ID) AND TMPL.AGC_ACTIVE_FLAG = 'Y' AND TMPL.AGC_SUB_BNR_TYPE NOT IN ('0000', '0005') |
| # | 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 |
| 2 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 3 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |