OBJECTOWNERIDHR_ATT_SUB_IDEFFDTDefault Value: %date
SEQNOHR_ATT_CNFG_IDA=Require at least one
O=Optional
R=Required
N=No Approval Required
Y=Approval Required
BEN_DOC_LIST_VW(SQL View) |
Index Back |
|---|---|
Document list viewDocument list view on Fluid Document upload page |
| SELECT DISTINCT A.OBJECTOWNERID , A.HR_ATT_SUB_ID , A.EFFDT , A.SEQNO , A.HR_ATT_CNFG_ID , B.HR_ATT_ENT_ID , A.HR_ATT_UPLD_REQ , A.HR_ATT_APPR_REQ FROM PS_HR_ATT_DFN_BN A , PS_HR_ATT_CNFG_DD B WHERE A.HR_ATT_CNFG_ID = B.HR_ATT_CNFG_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OBJECTOWNERID |
Character(4) | VARCHAR2(4) NOT NULL | Object owner identifier |
| 2 | HR_ATT_SUB_ID |
Character(4) | VARCHAR2(4) NOT NULL | Field to partition attachments keys entries |
| 3 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | SEQNO |
Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 5 | HR_ATT_CNFG_ID |
Character(18) | VARCHAR2(18) NOT NULL | Attachment Configuration |
| 6 | HR_ATT_ENT_ID | Character(18) | VARCHAR2(18) NOT NULL | Attachment Authorization Entry ID |
| 7 | HR_ATT_UPLD_REQ | Character(1) | VARCHAR2(1) NOT NULL |
Upload Required
O - Optional
R - Required
A - Required at Lease one
A=Require at least one O=Optional R=Required |
| 8 | HR_ATT_APPR_REQ | Character(1) | VARCHAR2(1) NOT NULL |
Approval Required
N=No Approval Required Y=Approval Required |