HEGIS_CODEEFFDTDefault Value: %date
SAD_HEGS_VW_NLD(SQL View) |
Index Back |
|---|---|
Hegis Code View for RekentoetsHegis Code View for Rekentoets |
| SELECT HG.HEGIS_CODE , HG.EFFDT FROM PS_SSR_HEGISCD_NLD HG WHERE HG.SCC_LOB_CODE_NLD = '1107' AND %EffdtCheck(SSR_HEGISCD_NLD HG1, HG, %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HEGIS_CODE |
Character(8) | VARCHAR2(8) NOT NULL | HEGIS Code |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |