HR_ATT_CNFG_VW

(SQL View)
Index Back

Configuration ID View

Existing Document Definition Page - Configuration ID Prompt View (Dynamic View)

SELECT HR_ATT_CNFG_ID , EFFDT FROM PS_HR_ATT_CNFG_TBL WHERE EFF_STATUS='A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 HR_ATT_CNFG_ID Character(18) VARCHAR2(18) NOT NULL Attachment Configuration
2 EFFDT Date(10) DATE Effective Date

Default Value: %date