| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 2 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Record
|
| 3 |
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
|
| 4 |
DUR |
Date(10) |
DATE NOT NULL |
Date Under Report associates time being reported, scheduled or paid, to a specific date.
|
| 5 |
SEQ_NO |
Number(2,0) |
SMALLINT NOT NULL |
Sequence Number
|
| 6 |
SEQNUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence Number
|
| 7 |
PUNCH_DTTM |
DateTime(26) |
TIMESTAMP NOT NULL |
Date and time when the punch occurred.
|
| 8 |
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
|
| 9 |
PUNCH_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Global Punch Types
0=Elapsed
1=In
2=Out
3=Meal
4=Break
5=Transfer
|
| 10 |
SCH_CATEGORY |
Character(2) |
VARCHAR2(2) NOT NULL |
Schedule Category
AB=Absence Management
MT=Meeting
OT=Other
RE=Replace
TR=Training
WK=Work
|
| 11 |
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
|
| 12 |
DESCR100 |
Character(100) |
VARCHAR2(100) NOT NULL |
Length 100 Description
|
| 13 |
DATETIME_CREATED |
DateTime(26) |
TIMESTAMP |
DateTime Created
|
| 14 |
ORIGINATORID |
Character(30) |
VARCHAR2(30) NOT NULL |
Originator Identifier
|
| 15 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|