| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 3 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Record
|
| 4 |
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
|
| 5 |
DUR |
Date(10) |
DATE |
Date Under Report associates time being reported, scheduled or paid, to a specific date.
|
| 6 |
SEQ_NO |
Number(2,0) |
SMALLINT NOT NULL |
Sequence Number
|
| 7 |
SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence
|
| 8 |
SEQNUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence Number
|
| 9 |
PUNCH_DTTM |
DateTime(26) |
TIMESTAMP |
Date and time when the punch occurred.
|
| 10 |
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
|
| 11 |
DATETIME_STAMP |
DateTime(26) |
TIMESTAMP |
DateTime Stamp
|
| 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 |
TL_QUANTITY |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
This field represents the measure of Work in hrs,amount etc.,
|
| 14 |
SCH_CATEGORY |
Character(2) |
VARCHAR2(2) NOT NULL |
Schedule Category
AB=Absence Management
MT=Meeting
OT=Other
RE=Replace
TR=Training
WK=Work
|
| 15 |
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
|
| 16 |
DATETIME_CREATED |
DateTime(26) |
TIMESTAMP |
DateTime Created
|
| 17 |
DESCR100 |
Character(100) |
VARCHAR2(100) NOT NULL |
Length 100 Description
|
| 18 |
ORIGINATORID |
Character(30) |
VARCHAR2(30) NOT NULL |
Originator Identifier
|