EODS_AUDIT_WRK(SQL Table) |
Index Back |
|---|---|
View combining Audit RecordsThis view combines the Audit Header and Detail records. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DSMAPNAME | Character(50) | VARCHAR2(50) NOT NULL | Directory Entry Map Name |
| 2 | DSDN | Character(200) | VARCHAR2(200) NOT NULL | Distinguished Name |
| 3 | LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 4 | EODS_AUDIT_T_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Audit TransactionType
A=Add D=Delete U=Update |
| 5 | EODS_USER_ID | Character(30) | VARCHAR2(30) NOT NULL | User Id |
| 6 | EODS_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status
N=No Success S=Successful |
| 7 | DSOUTPUTTYPE | Character(2) | VARCHAR2(2) NOT NULL |
Output Type
F=File Format I=Business Interlink |
| 8 | DSAUDITACTN | Character(2) | VARCHAR2(2) NOT NULL |
Directory Audit Action
AA=Attribute Add AD=Attribute Delete AM=Attribute Modify DA=Distinguish Name Add DD=Distinguish Name Delete DM=Distinguish Name Modify |
| 9 | DSATTRIBUTE | Character(50) | VARCHAR2(50) NOT NULL | Directory Attribute |
| 10 | EODS_ATTR_VALUE | Character(55) | VARCHAR2(55) NOT NULL | Attibute Value |