SCH_OWS_AET

(SQL Table)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 INCL_ML_BRK_FLG Character(1) VARCHAR2(1) NOT NULL Schedule Totaling
1=Exclude Breaks and Meals
2=Include Meals
3=Include Breaks
4=Include Breaks and Meals

3 MESSAGE_ID Character(30) VARCHAR2(30) NOT NULL Message ID

4 URL Character(254) VARCHAR2(254) NOT NULL Internet URL (Universal Resource Locator)

5 START_DATE Date(10) DATE Start Date for Gen Standing PO

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

7 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

8 TRC Character(5) VARCHAR2(5) NOT NULL Time Reporting Code used to report time in Time and Labor

9 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

10 TL_FROM_DATE Date(10) DATE Reporting Date Range

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

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

13 PUNCH_DTTM DateTime(26) TIMESTAMP Date and time when the punch occurred.

14 TRC1 Character(5) VARCHAR2(5) NOT NULL TRC -- used in rule templates.

15 DUR_DB Date(10) DATE Date Under Report associates time being reported, scheduled or paid, to a specific date.

16 COMP_LEAV_IND Character(4) VARCHAR2(4) NOT NULL Comp Leave Indiactor indicates whether a TRC has any effect on Leave and Compensatory time Off
CERN=Comp Time Earned
CTKN=Comp Time Taken
LTKN=Leave Taken
NO=No Comp Time Effect
RULE=Avoid Replacing by Rules

17 COMP_TIME_PLAN Character(10) VARCHAR2(10) NOT NULL Compensatory Time Off Plan

18 TL_QUANTITY Signed Number(20,6) DECIMAL(18,6) NOT NULL This field represents the measure of Work in hrs,amount etc.,

19 END_BAL Signed Number(9,3) DECIMAL(7,3) NOT NULL Ending Balance

20 CURRENT_BAL Signed Number(9,3) DECIMAL(7,3) NOT NULL Current Balance

21 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

22 TL_QUANTITY1 Signed Number(20,6) DECIMAL(18,6) NOT NULL Quantity

23 SEQ_NBR1 Number(15,0) DECIMAL(15) NOT NULL Sequence Number

24 EMPLID_NEW Character(11) VARCHAR2(11) NOT NULL ID

25 EMPL_RCD_NEW Number(3,0) SMALLINT NOT NULL Next Empl Rcd

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

27 BENEFIT_RCD_NBR Number(3,0) SMALLINT NOT NULL Specifies a sequence number associated with each of multiple concurrent jobs for a one employee. It is used to determine the applicable benefit program for each job. The first job entered for an employee is automatically assigned a Benefit Record Number of zero (0). This field is linked with EMPL_RCD#, the Employment Record Number.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	INCL_ML_BRK_FLG	Character(1)	VARCHAR2(1) NOT NULL	Schedule Totaling 1=Exclude Breaks and Meals 2=Include Meals 3=Include Breaks 4=Include Breaks and Meals
3	MESSAGE_ID	Character(30)	VARCHAR2(30) NOT NULL	Message ID
4	URL	Character(254)	VARCHAR2(254) NOT NULL	Internet URL (Universal Resource Locator)
5	START_DATE	Date(10)	DATE	Start Date for Gen Standing PO
6	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
7	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
8	TRC	Character(5)	VARCHAR2(5) NOT NULL	Time Reporting Code used to report time in Time and Labor
9	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
10	TL_FROM_DATE	Date(10)	DATE	Reporting Date Range
11	SEQ_NO	Number(2,0)	SMALLINT NOT NULL	Sequence Number
12	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
13	PUNCH_DTTM	DateTime(26)	TIMESTAMP	Date and time when the punch occurred.
14	TRC1	Character(5)	VARCHAR2(5) NOT NULL	TRC -- used in rule templates.
15	DUR_DB	Date(10)	DATE	Date Under Report associates time being reported, scheduled or paid, to a specific date.
16	COMP_LEAV_IND	Character(4)	VARCHAR2(4) NOT NULL	Comp Leave Indiactor indicates whether a TRC has any effect on Leave and Compensatory time Off CERN=Comp Time Earned CTKN=Comp Time Taken LTKN=Leave Taken NO=No Comp Time Effect RULE=Avoid Replacing by Rules
17	COMP_TIME_PLAN	Character(10)	VARCHAR2(10) NOT NULL	Compensatory Time Off Plan
18	TL_QUANTITY	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	This field represents the measure of Work in hrs,amount etc.,
19	END_BAL	Signed Number(9,3)	DECIMAL(7,3) NOT NULL	Ending Balance
20	CURRENT_BAL	Signed Number(9,3)	DECIMAL(7,3) NOT NULL	Current Balance
21	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
22	TL_QUANTITY1	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Quantity
23	SEQ_NBR1	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
24	EMPLID_NEW	Character(11)	VARCHAR2(11) NOT NULL	ID
25	EMPL_RCD_NEW	Number(3,0)	SMALLINT NOT NULL	Next Empl Rcd
26	DUR	Date(10)	DATE	Date Under Report associates time being reported, scheduled or paid, to a specific date.
27	BENEFIT_RCD_NBR	Number(3,0)	SMALLINT NOT NULL	Specifies a sequence number associated with each of multiple concurrent jobs for a one employee. It is used to determine the applicable benefit program for each job. The first job entered for an employee is automatically assigned a Benefit Record Number of zero (0). This field is linked with EMPL_RCD#, the Employment Record Number.