AUDIT_SCHO_REJ (SQL Table)	Index Back
Schedule OWS Audit Rejected This table is a audit used to store all rejected records sent from the source system. It is used as record message structure.

AUDIT_SCHO_REJ

(SQL Table)

Schedule OWS Audit Rejected

This table is a audit used to store all rejected records sent from the source system. It is used as record message structure.

# 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 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 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

6 SCH_PRIM_ALT_IND Character(1) VARCHAR2(1) NOT NULL Indicates whether this is the employee's Primary or Alternate SChedule
A=Alternate
P=Primary

7 DUR Date(10) DATE NOT NULL Date Under Report associates time being reported, scheduled or paid, to a specific date.

8 SEQ_NO Number(2,0) SMALLINT NOT NULL Sequence Number

9 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number

10 PUNCH_DTTM DateTime(26) TIMESTAMP NOT NULL Date and time when the punch occurred.

11 SCHED_SOURCE Character(2) VARCHAR2(2) NOT NULL Schedule Source indicates the source of Time Reporter Detail Schedule information.
E=Enterprise Learning Management
I=Third Party Import
L=Long Term Schedule
O=On-Line Change

12 PUNCH_TYPE Character(2) VARCHAR2(2) NOT NULL Global Punch Types
0=Elapsed
1=In
2=Out
3=Meal
4=Break
5=Transfer

13 SCH_CATEGORY Character(2) VARCHAR2(2) NOT NULL Schedule Category
AB=Absence Management
MT=Meeting
OT=Other
RE=Replace
TR=Training
WK=Work

14 SCH_REJECT_REASON Character(2) VARCHAR2(2) NOT NULL Schedule Rejected Reason
01=Invalid Employee & Empl Record
02=Invalid Schedule Source
03=Invalid Category
04=Invalid Punch Type
05=Invalid Activity
06=Invalid Activity Type
07=Invalid Event
08=Invalid Time Zone
09=Transaction already exists
10=Cannot add. Tran exists.
11=Cannot chg/del. Tr. exists.
12=Not Enrolled Integration
13=Not enrolled Time Reporter
14=Leave balance not sufficient
15=TRC is blank
16=TRC is not active
17=Not Enrolled Leave Benefit

15 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description

16 ORIGINATORID Character(30) VARCHAR2(30) NOT NULL Originator Identifier

17 DATETIME_CREATED DateTime(26) TIMESTAMP DateTime Created

#	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	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	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
6	SCH_PRIM_ALT_IND	Character(1)	VARCHAR2(1) NOT NULL	Indicates whether this is the employee's Primary or Alternate SChedule A=Alternate P=Primary
7	DUR	Date(10)	DATE NOT NULL	Date Under Report associates time being reported, scheduled or paid, to a specific date.
8	SEQ_NO	Number(2,0)	SMALLINT NOT NULL	Sequence Number
9	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
10	PUNCH_DTTM	DateTime(26)	TIMESTAMP NOT NULL	Date and time when the punch occurred.
11	SCHED_SOURCE	Character(2)	VARCHAR2(2) NOT NULL	Schedule Source indicates the source of Time Reporter Detail Schedule information. E=Enterprise Learning Management I=Third Party Import L=Long Term Schedule O=On-Line Change
12	PUNCH_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Global Punch Types 0=Elapsed 1=In 2=Out 3=Meal 4=Break 5=Transfer
13	SCH_CATEGORY	Character(2)	VARCHAR2(2) NOT NULL	Schedule Category AB=Absence Management MT=Meeting OT=Other RE=Replace TR=Training WK=Work
14	SCH_REJECT_REASON	Character(2)	VARCHAR2(2) NOT NULL	Schedule Rejected Reason 01=Invalid Employee & Empl Record 02=Invalid Schedule Source 03=Invalid Category 04=Invalid Punch Type 05=Invalid Activity 06=Invalid Activity Type 07=Invalid Event 08=Invalid Time Zone 09=Transaction already exists 10=Cannot add. Tran exists. 11=Cannot chg/del. Tr. exists. 12=Not Enrolled Integration 13=Not enrolled Time Reporter 14=Leave balance not sufficient 15=TRC is blank 16=TRC is not active 17=Not Enrolled Leave Benefit
15	DESCR100	Character(100)	VARCHAR2(100) NOT NULL	Length 100 Description
16	ORIGINATORID	Character(30)	VARCHAR2(30) NOT NULL	Originator Identifier
17	DATETIME_CREATED	DateTime(26)	TIMESTAMP	DateTime Created