| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table:
SP_SETID_NONVW
|
| 2 |
PROJ_ROLE |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Role
Prompt Table:
SPB_PJROL_R_VW1
|
| 3 |
ASSIGNMENT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Work Assignment ID
Prompt Table:
SPB_ASGN_VW
|
| 4 |
EFFDT |
Date(10) |
DATE |
Effective Date
Default Value: %date
|
| 5 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 6 |
ASSIGNMENT_SRV_DT |
Character(1) |
VARCHAR2(1) NOT NULL |
Assignment by service Detail definition
D=Define for this Service
U=Use Assignment Definition
V=Disable for this Service
|
| 7 |
ASSIGNMENT_TM |
Character(1) |
VARCHAR2(1) NOT NULL |
Assignment Based on Time
Y/N Table Edit
Default Value: N
|
| 8 |
ASSIGNMENT_PAY |
Character(1) |
VARCHAR2(1) NOT NULL |
Assignment Pay
A=Add to Work Order Rate
P=Add % of Work Order Rate
S=Substitute Work Order Rate
|
| 9 |
ASSIGNMENT_PCT |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Assignment Percent
|
| 10 |
SP_PAY_RATE |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
pay rate
|
| 11 |
SP_FIXED_COST |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
fixed costs
|
| 12 |
SP_VNDR_MARKUP |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
vendor markup
|
| 13 |
SP_3RDPARTY_MARKUP |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
third party markup amount
|
| 14 |
ASSIGNMENT_RT |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
Assignment Rate
|
| 15 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 16 |
UNIT_OF_MEASURE |
Character(3) |
VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
Prompt Table:
SPF_UOM_VW
|
| 17 |
ASSIGNMENT_INCDT |
Character(1) |
VARCHAR2(1) NOT NULL |
Assignment Based on Incident
Y/N Table Edit
Default Value: N
|
| 18 |
SP_PAY_RATE2 |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
pay rate
|
| 19 |
SP_FIXED_COST2 |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
fixed costs
|
| 20 |
SP_VNDR_MARKUP2 |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
vendor markup
|
| 21 |
SP_3RDPARTY_MRKUP2 |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
third party markup amount
|
| 22 |
ASSIGNMENT_INCRATE |
Signed Number(16,4) |
DECIMAL(14,4) NOT NULL |
Assignment Incident Rate
|