ACA_SFE_CODE_VW(SQL View) |
Index Back |
---|---|
Safe Harbor code search promptSafe Harbor code search prompt view |
SELECT ACA_SAFE_HARBOR_CD , EFFDT , DESCR FROM PS_ACA_SFE_HB_CODE WHERE ACA_OTHER_RELIF = 'Y' |
# | 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 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |