| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SP_BU_PM_NONVW
|
| 2 |
SP_REQ_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Service Request ID
Default Value: NEXT
|
| 3 |
LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Line Number:
11/24/08 - Added TARGET label [PC product]
|
| 4 |
SPB_REQ_II_SRC |
Character(1) |
VARCHAR2(1) NOT NULL |
Parallel sourcing
D=Done
N=Not Required
R=Ready
S=Send to SC
Default Value: N
|
| 5 |
SP_TRACK_RESRC |
Character(1) |
VARCHAR2(1) NOT NULL |
Track Resource
B=Default From Business Unit
N=No
Y=Yes
Default Value: N
|
| 6 |
SP_RATES_BY_SC |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag for Rate definition by SC - Translate values
D - Rate defined by SC
N - Not applicable
P - Pending Rate Synchronization
R - Ready for rate definition.
S - Sent to SC for rate definition.
D=Rate Defined by SC
N=Not Applicable
P=Pending Rate Synchronization
R=Ready for rate
S=Sent to SC for Rate
Default Value: N
|
| 7 |
VMS_SUPPLIER_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
VMS Supplier ID
|
| 8 |
VMS_LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
VMS Location - This is the Vendor Managed Service Supplier's office location
|
| 9 |
SP_TIME_REPORT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Time Reporting Option
A=Actual Allocation
D=Default from Business Unit
P=Percent Allocation
Default Value: P
|
| 10 |
SP_EXP_REPORT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Expense Reporting Option
A=Actual Allocation
D=Default from Business Unit
P=Percent Allocation
|
| 11 |
SP_ALLOW_OVRIDE_RT |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag used in the rate sheet page. It will indicated whether to allow rate override on the requisition page.
Y/N Table Edit
Default Value: Y
|
| 12 |
REG_REGION |
Character(5) |
VARCHAR2(5) NOT NULL |
Regulatory Region
Prompt Table:
REG_REGION_TBL
|
| 13 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
Prompt Table:
COMPANY_TBL
|
| 14 |
BUSINESS_UNIT_HR |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit HR
Prompt Table:
BUS_UNIT_TBL_HR
|
| 15 |
DEPTID_JOB_SP |
Character(10) |
VARCHAR2(10) NOT NULL |
HCM Department ID
Prompt Table:
DEPT_TBL_EFF_VW
Set Control Field: BUSINESS_UNIT_HR
|
| 16 |
LOCATION_JOB_SP |
Character(10) |
VARCHAR2(10) NOT NULL |
HCM Job Location
Prompt Table:
LOCATION_TBL
Set Control Field: BUSINESS_UNIT_HR
|
| 17 |
JOBCODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Code
Prompt Table:
SP_JOBCODE_VW1
Set Control Field: BUSINESS_UNIT_HR
|
| 18 |
LABOR_AGREEMENT |
Character(6) |
VARCHAR2(6) NOT NULL |
Labor Agreement
Prompt Table:
SP_LBR_AGRMT_VW
Set Control Field: BUSINESS_UNIT_HR
|
| 19 |
ESTABID |
Character(12) |
VARCHAR2(12) NOT NULL |
Establishment ID
Prompt Table:
ESTAB_TBL
|
| 20 |
SP_HCM_DEFLT_ADMIN |
Character(30) |
VARCHAR2(30) NOT NULL |
Default HCM Administrator
Prompt Table:
PSOPRDEFN_VW
|
| 21 |
CHNG_ORD_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Change Order Sequence Number
|
| 22 |
SPF_JOB_DESCRLONG |
Long Character |
CLOB NOT NULL |
stores the job description for a sp requisition.
|
| 23 |
LINKED_SRVC_SEQNBR |
Number(5,0) |
INTEGER NOT NULL |
Linked Service Seqnbr
|