HR_ATT_DFN_BN(SQL Table) |
Index Back |
|---|---|
Attachment Definition TableAttachment Definition table used to capture values for attachment Required and upload Required fields. These field values are displayed on maintain Definition setup page of Attachments. This Record has same key structure of HR_ATT_DFN_ATCH table |
| # | 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 NOT NULL |
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
Prompt Table: HR_ATT_CNFG_TBL |
| 6 | 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 Default Value: O |
| 7 | HR_ATT_APPR_REQ | Character(1) | VARCHAR2(1) NOT NULL |
Approval Required
N=No Approval Required Y=Approval Required Default Value: N |
| 8 | SYSTEM_DATA_FLG | Character(1) | VARCHAR2(1) NOT NULL |
This Y/ N field is used to identify which rows in a table are considered SYSTEM DATA.
Y/N Table Edit Default Value: N |