ACA_SAFE_HARBOR_CDEFFDTDefault Value: %date
LANGUAGE_CDACA_SFECDLNG_VW(SQL View) |
Index Back |
|---|---|
Safe Harbor code search LNGSafe Harbor code search prompt Language view |
| SELECT L.ACA_SAFE_HARBOR_CD , L.EFFDT , L.Language_cd , L.DESCR FROM PS_ACA_SFEHBCD_LNG L WHERE L.EFFDT = ( SELECT MAX(S.EFFDT) FROM PS_ACA_SFE_CODE_VW S WHERE S.ACA_SAFE_HARBOR_CD = L.ACA_SAFE_HARBOR_CD AND S.EFFDT <=%CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ACA_SAFE_HARBOR_CD |
Character(4) | VARCHAR2(4) NOT NULL | Safe Harbor Code |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |