HR_ATT_ENT_IDEFFDTDefault Value: %date
ROLENAMEPrompt Table: PSROLEDEFN
Prompt Table: HR_ATT_AUTH_TBL
Y/N Table Edit
Default Value: N
HR_ATT_ENT_ROL(SQL Table) |
Index Back |
|---|---|
Attachment Auth Entries RolesAttachment Authorization Entries Roles Record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HR_ATT_ENT_ID |
Character(18) | VARCHAR2(18) NOT NULL | Attachment Authorization Entry ID |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | ROLENAME |
Character(30) | VARCHAR2(30) NOT NULL |
The name of a Role in the Role Definition Table (see PSROLEDEFN).
Prompt Table: PSROLEDEFN |
| 4 | HR_ATT_AUTH_ID | Character(18) | VARCHAR2(18) NOT NULL |
Attachment Authorization ID
Prompt Table: HR_ATT_AUTH_TBL |
| 5 | 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 |