HRS_PERSON_IDEMPLIDRECNAMEAUDIT_OPRIDAUDIT_STAMPHRS_OVR_AWD_VW(SQL View) |
Index Back |
|---|
| SELECT %Sql(funclib_hr_math_to_number, %Substring(A.KEY1, 1, 15)) , %Substring(A.KEY2,1,11) , A.RECNAME , A.AUDIT_OPRID , A.AUDIT_STAMP , A.FIELDNAME , A.OLDVALUE , A.NEWVALUE , B.EMPLID FROM PSAUDIT A , PSOPRDEFN B WHERE A.RECNAME = 'HRS_EE_REF_AWD' AND A.AUDIT_OPRID = B.OPRID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HRS_PERSON_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Person Id |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | RECNAME |
Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 4 | AUDIT_OPRID |
Character(30) | VARCHAR2(30) NOT NULL | The OPRID of the user who made the changes audited on an audit record. |
| 5 | AUDIT_STAMP |
DateTime(26) | TIMESTAMP | Date and Time Stamp |
| 6 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 7 | OLDVALUE | Character(65) | VARCHAR2(65) NOT NULL | Old Value |
| 8 | NEWVALUE | Character(65) | VARCHAR2(65) NOT NULL | New Value |
| 9 | OPR_EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Operators EmplID |