| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 2 |
TIME_SHEET_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Time Sheet Unique Identifier (System Generated)
|
| 3 |
WORK_ORDER_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Work Order ID
Prompt Table:
SPA_TIME_WO2_VW
|
| 4 |
HISTORY_DTTM |
DateTime(26) |
TIMESTAMP |
History Date/Time
Default Value: %datetime
|
| 5 |
LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Line Number:
11/24/08 - Added TARGET label [PC product]
Default Value: 1
|
| 6 |
DISTRIB_LINE_NUM |
Number(5,0) |
INTEGER NOT NULL |
Distribution Line
|
| 7 |
SPA_BILLING_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Billing Action
B=Billable
U=Nonbillable
Default Value: B
|
| 8 |
SP_TIME_QTY |
Signed Number(18,4) |
DECIMAL(16,4) NOT NULL |
Time Quantity
|
| 9 |
TIME_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Time Amount
|
| 10 |
TIME_AMOUNT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Time Amount Base Currency
|
| 11 |
ACTIVITY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity ID
Prompt Table:
PROJ_ACT_FS
|
| 12 |
SHIFT_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Shift ID
|
| 13 |
ASSIGNMENT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Work Assignment ID
|
| 14 |
TIME_LINE_STATUS |
Character(3) |
VARCHAR2(3) NOT NULL |
Time Line Status
ADJ=Adjusted
APR=Approved
DEN=Denied
OPN=Open
PND=Pending
SUB=Submitted
|
| 15 |
APPROVAL_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A system generated value that reflects the operator that approved a given transaction.
|
| 16 |
APPROVAL_DT |
Date(10) |
DATE |
Date of Approval
|
| 17 |
APPR_RATINGS |
Character(1) |
VARCHAR2(1) NOT NULL |
Approver ratings of contractor.
E=Excellent
F=Fair
G=Good
N=None
P=Poor
Default Value: N
|
| 18 |
APPR_RATING_NUM |
Number(4,2) |
DECIMAL(3,2) NOT NULL |
Performance Rating
Default Value: 0
|
| 19 |
TE_INVOICE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Time and expense invoiced flag
N=No
Y=Yes
Default Value: N
|
| 20 |
INVOICE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Invoice Number
|
| 21 |
INVOICE_LINE |
Number(5,0) |
INTEGER NOT NULL |
Invoice Line
|
| 22 |
INV_LINE_STATUS |
Character(4) |
VARCHAR2(4) NOT NULL |
Invoice Line Status
1=Generated
10=Adjusted by Ent Approver
11=Adjusted by Enterprise
2=Approved by Enterprise
3=Submitted to Enterprise
4=Denied by Enterprise
5=Submitted to Supplier
6=Approved by Supplier
7=Denied by Supplier
8=Canceled
9=Adjusted by Supplier
|
| 23 |
SP_MSP_FEE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Managed Service Provider Fee
|
| 24 |
SP_MSP_FEE_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Managed Service Provider Fee (Base Currency)
|
| 25 |
PC_DISTRIB_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
PC Distribution Status
B=Budget Check
D=Distributed
G=Generated
H=Hold
I=Ignore
M=Modified
N=Not Distributed
S=Staged
|
| 26 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 27 |
CURRENCY_CD_BASE |
Character(3) |
VARCHAR2(3) NOT NULL |
Business Unit Base Currency
|
| 28 |
DESCR60 |
Character(60) |
VARCHAR2(60) NOT NULL |
Description
|
| 29 |
DESCR254 |
Character(254) |
VARCHAR2(254) NOT NULL |
Description of length 254
|