AUDIT_PERSONAL (SQL Table)	Index Back
Personal Data Audited Fields The system uses AUDIT_PERSONAL as an audit trail to track operators who access employees' PERSONAL_DATA records.

AUDIT_PERSONAL

(SQL Table)

Personal Data Audited Fields

The system uses AUDIT_PERSONAL as an audit trail to track operators who access employees' PERSONAL_DATA records.

Audit Record Of GVT_CURR_PERS_V GVT_CURV_LNG_VW GVT_PD_PUSH_VW GVT_PERS_DATA GVT_PERS_LANG GVT_PERS_TEMP

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 AUDIT_OPRID Character(30) VARCHAR2(30) NOT NULL The OPRID of the user who made the changes audited on an audit record.

2 AUDIT_STAMP DateTime(26) TIMESTAMP NOT NULL Date and Time Stamp

3 AUDIT_ACTN Character(1) VARCHAR2(1) NOT NULL Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add
C=Change Old (PPR Only)
D=Delete
K=Change - Old Values
N=Change - New Values
O=Change - Original Values

4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

5 NAME Character(50) VARCHAR2(50) NOT NULL Name

6 SSN Character(9) VARCHAR2(9) NOT NULL Social Security #

7 SIN Character(9) VARCHAR2(9) NOT NULL Social Insurance #

8 PER_ORG Character(3) VARCHAR2(3) NOT NULL Defines the Organizational Relationship(s) that a Person has to the Organization. These are Employee, Contingent Worker, and Persons of Interest.
CWR=Contingent Worker
EMP=Employee
POI=Person of Interest

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	AUDIT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	The OPRID of the user who made the changes audited on an audit record.
2	AUDIT_STAMP	DateTime(26)	TIMESTAMP NOT NULL	Date and Time Stamp
3	AUDIT_ACTN	Character(1)	VARCHAR2(1) NOT NULL	Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted. A=Add C=Change Old (PPR Only) D=Delete K=Change - Old Values N=Change - New Values O=Change - Original Values
4	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
5	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
6	SSN	Character(9)	VARCHAR2(9) NOT NULL	Social Security #
7	SIN	Character(9)	VARCHAR2(9) NOT NULL	Social Insurance #
8	PER_ORG	Character(3)	VARCHAR2(3) NOT NULL	Defines the Organizational Relationship(s) that a Person has to the Organization. These are Employee, Contingent Worker, and Persons of Interest. CWR=Contingent Worker EMP=Employee POI=Person of Interest