| # |
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 |
DATE_UNDER_RPT |
Date(10) |
DATE |
Date Under Report
|
| 4 |
SEQNUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence Number
|
| 5 |
DLYTASK_SEQNUM |
Number(3,0) |
SMALLINT NOT NULL |
Daily Task Sequence Number
|
| 6 |
SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sequence Number
|
| 7 |
BORROW_TSKGRP |
Character(10) |
VARCHAR2(10) NOT NULL |
Borrowing Taskgroup
|
| 8 |
TSKGRP_OVRD_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Current Taskgroup
|
| 9 |
SHIFT_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Shift ID
|
| 10 |
TRC |
Character(5) |
VARCHAR2(5) NOT NULL |
Time Reporting Code used to report time in Time and Labor
|
| 11 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
|
| 12 |
LOCALITY |
Character(10) |
VARCHAR2(10) NOT NULL |
Locality
|
| 13 |
ORIG_TASKGROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Original Taskgroup
|
| 14 |
OVERRIDE_RATE |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Override Rate.
|
| 15 |
EST_GROSS |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Estimated Gross
|
| 16 |
LBR_DIST_AMT |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Labor Distribution Amount
|
| 17 |
QUANTITY_TMP |
Signed Number(12,5) |
DECIMAL(10,5) NOT NULL |
Quantity
|
| 18 |
REPORTED_HRS |
Signed Number(10,5) |
DECIMAL(8,5) NOT NULL |
Reported Hours
|
| 19 |
REPORTED_AMT |
Signed Number(12,5) |
DECIMAL(10,5) NOT NULL |
Reported Amount
|
| 20 |
REPORTED_UNITS |
Signed Number(12,5) |
DECIMAL(10,5) NOT NULL |
Reported Units
|
| 21 |
PROCESS_STATE_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Process State Indicator
A=Approved Time
C=Created Time
D=Range of Dates Update
E=Edited Time
L=Labor Distributed
M=Lump Sum Update
P=Pattern Update
R=Rules Applied
S=Scheduled Time
T=Reported Time
U=Rapid Time Update
W=Crew Update
|
| 22 |
APPROVAL_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Approval Flag
|
| 23 |
LABOR_DIST_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Labor Distribution Flag
|
| 24 |
RULE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Rule Flag
N=Batch Rules Not Applied
X=Chgd since Batch Rules Appld
Y=Batch Rules Applied
|
| 25 |
SCHEDULE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Schedule Flag
|
| 26 |
REPORTED_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Reported Flag
|
| 27 |
PROJECT_COST_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Project Costing Flag
|
| 28 |
PC_DISTRIB_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Projects Distribution Status
D=Distributed
F=Finalized
G=Generated
H=Hold
I=Ignore
M=Modified
N=None
|
| 29 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 30 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
|
| 31 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
|
| 32 |
PRODUCT |
Character(6) |
VARCHAR2(6) NOT NULL |
Product
|
| 33 |
CUSTOMER |
Character(10) |
VARCHAR2(10) NOT NULL |
Customer
|
| 34 |
ACCT_CD |
Character(25) |
VARCHAR2(25) NOT NULL |
Combination Code
|
| 35 |
BUSINESS_UNIT_PC |
Character(5) |
VARCHAR2(5) NOT NULL |
Project Costing Business Unit
|
| 36 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project/Grant
|
| 37 |
ACTIVITY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity ID
|
| 38 |
RESOURCE_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Project Costing Resource Type
|
| 39 |
RESOURCE_CATEGORY |
Character(5) |
VARCHAR2(5) NOT NULL |
Project Costing Resource Category
|
| 40 |
RESOURCE_SUB_CAT |
Character(5) |
VARCHAR2(5) NOT NULL |
Project Costing Resource Sub Category
|
| 41 |
TASK |
Character(5) |
VARCHAR2(5) NOT NULL |
Task
|
| 42 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 43 |
UPDT_PAYROLL_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Updated to Payroll
N=Not Updated to Payroll
X=Changed Since Updtd to Payroll
Y=Updated to Payroll
|
| 44 |
USER_FIELD_1 |
Character(10) |
VARCHAR2(10) NOT NULL |
User Field 1
|
| 45 |
USER_FIELD_2 |
Character(10) |
VARCHAR2(10) NOT NULL |
User Field 2
|
| 46 |
USER_FIELD_3 |
Character(15) |
VARCHAR2(15) NOT NULL |
User Field 3
|
| 47 |
USER_FIELD_4 |
Character(20) |
VARCHAR2(20) NOT NULL |
User Field 4
|
| 48 |
USER_FIELD_5 |
Character(20) |
VARCHAR2(20) NOT NULL |
User Field 5
|
| 49 |
PERIOD_PRCS_DT |
Date(10) |
DATE |
Period Process Date
|
| 50 |
ORIG_TL_QTY |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Original TL Quantity used in rules processing.
|
| 51 |
RULE_ID_ER |
Character(12) |
VARCHAR2(12) NOT NULL |
Rule ID
|
| 52 |
ORIG_TRC |
Character(5) |
VARCHAR2(5) NOT NULL |
Original Time Rptg Cd
|
| 53 |
TRC_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
This defines TRC Type of Hours,Amounts ,Units
A=Amount
H=Hours
U=Units
|
| 54 |
SOURCE_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates the source of payable time.
S - system generated
U - User entered
O - Offset
O=Offset
S=System Generated
U=User Reported
|
| 55 |
ORIG_SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Original Sequence Number
|
| 56 |
COMP_RATECD |
Character(6) |
VARCHAR2(6) NOT NULL |
Comp Rate Code
|