| # |
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 |
LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Line Number:
11/24/08 - Added TARGET label [PC product]
Default Value: 1
|
| 5 |
DISTRIB_LINE_NUM |
Number(5,0) |
INTEGER NOT NULL |
Distribution Line
Prompt Table:
SPF_WO_DIST_VW
|
| 6 |
ACTIVITY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity ID
Prompt Table:
SPF_ACTIVITY_VW
|
| 7 |
ASSIGNMENT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Work Assignment ID
|
| 8 |
DATE_UNDER_RPT |
Date(10) |
DATE |
Date Under Report
|
| 9 |
NUM_OF_INCIDENTS |
Number(16,0) |
DECIMAL(16) NOT NULL |
Number of incidents
|
| 10 |
TIME_LINE_STATUS |
Character(3) |
VARCHAR2(3) NOT NULL |
Time Line Status
ADJ=Adjusted
APR=Approved
DEN=Denied
OPN=Open
PND=Pending
SUB=Submitted
Default Value: OPN
|
| 11 |
TIME_ADJUSTED_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag to indicate timesheet has been adjusted
A=Adjusted
N=Not Adjusted
Default Value: N
|
| 12 |
SPA_BILLING_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Billing Action
B=Billable
U=Nonbillable
Default Value: B
|
| 13 |
ASSIGNMENT_INCRATE |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
Assignment Incident Rate
|
| 14 |
ASGN_INCRATE_BSE |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
Assignment Incident Rate base
|
| 15 |
SP_PAY_RATE |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
pay rate
|
| 16 |
SP_PAY_RATE_BSE |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
pay rate in the base currency
|
| 17 |
SP_FIXED_COST |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
fixed costs
|
| 18 |
SP_FIXED_COST_BSE |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
fixed costs in the base currency
|
| 19 |
SP_VNDR_MARKUP |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
vendor markup
|
| 20 |
SP_VNDR_MARKUP_BSE |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
vendor markup in the base currency
|
| 21 |
SP_3RDPARTY_MARKUP |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
third party markup amount
|
| 22 |
SP_3RDPTY_MKUP_BSE |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
third party markup amount in the base currency
|
| 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 |
SP_MSP_PERCENT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
MSP percent
|
| 26 |
TIME_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Time Amount
|
| 27 |
TIME_AMOUNT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Time Amount Base Currency
|
| 28 |
RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
|
| 29 |
RATE_EFFDT |
Date(10) |
DATE |
Rate Effective Date
|
| 30 |
RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
|
| 31 |
RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 32 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 33 |
CURRENCY_CD_ASGN |
Character(3) |
VARCHAR2(3) NOT NULL |
Assignment Currency
|
| 34 |
CURRENCY_CD_BASE |
Character(3) |
VARCHAR2(3) NOT NULL |
Business Unit Base Currency
|
| 35 |
APPROVAL_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A system generated value that reflects the operator that approved a given transaction.
|
| 36 |
APPROVAL_DT |
Date(10) |
DATE |
Date of Approval
|
| 37 |
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
|
| 38 |
APPR_RATING_NUM |
Number(4,2) |
DECIMAL(3,2) NOT NULL |
Performance Rating
Default Value: 0
|
| 39 |
TE_INVOICE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Time and expense invoiced flag
N=No
Y=Yes
Default Value: N
|
| 40 |
INVOICE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Invoice Number
|
| 41 |
INVOICE_LINE |
Number(5,0) |
INTEGER NOT NULL |
Invoice Line
|
| 42 |
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
|
| 43 |
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
|
| 44 |
DESCR254 |
Character(254) |
VARCHAR2(254) NOT NULL |
Description of length 254
|