| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PERSON_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Person ID
Prompt Table:
SPB_PERSON_TBL
|
| 2 |
SP_FUNCTION_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Function Type
INDP=Independent Provider
PRCT=Provider Contact
PROV=Provider
|
| 3 |
EFFDT |
Date(10) |
DATE |
Effective Date
Default Value: %date
|
| 4 |
VENDOR_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Vendor SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table:
SP_SETID_NONVW
|
| 5 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table:
VENDOR_SP_VW3
Set Control Field: VENDOR_SETID
|
| 6 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
Prompt Table:
SPB_LOCATION_VW
Set Control Field: VENDOR_SETID
|
| 7 |
PROVIDER_CONTACT |
Character(15) |
VARCHAR2(15) NOT NULL |
PROVIDER CONTACT
Prompt Table:
SPB_VNDR_PC_VW
Set Control Field: VENDOR_SETID
|
| 8 |
SETID_PROJROLE |
Character(5) |
VARCHAR2(5) NOT NULL |
Project Role Setid
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table:
SP_SETID_NONVW
|
| 9 |
PROJ_ROLE |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Role
Prompt Table:
SPB_SRVC_PRJROL
Set Control Field: SETID_PROJROLE
|
| 10 |
WORK_STATUS |
Character(4) |
VARCHAR2(4) NOT NULL |
Work Status of a person
1=US Citizen
2=GC Holder
3=H-1 Visa
4=NAFTA
9999=Other
|
| 11 |
ACTIVE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Event Status
N=Inactive
Y=Active
Default Value: Y
|
| 12 |
REASONCD |
Character(3) |
VARCHAR2(3) NOT NULL |
Reason Code
NOP=Not on Project
ONP=On Project
|
| 13 |
SPF_YRS_EXPERIENCE |
Character(4) |
VARCHAR2(4) NOT NULL |
Years Experience
Prompt Table:
SP_EXPERIENCE
Set Control Field: BUSINESS_UNIT
|
| 14 |
TRAVEL_REQUIRED |
Character(1) |
VARCHAR2(1) NOT NULL |
Travel Required
N=No
Y=Yes
Y/N Table Edit
|
| 15 |
TELECOMMUTE |
Character(1) |
VARCHAR2(1) NOT NULL |
Defines if the user telecommutes or not
N=No
Y=Yes
Y/N Table Edit
|
| 16 |
SPB_IS_ADMIN |
Character(1) |
VARCHAR2(1) NOT NULL |
field used in spro user setup to flag user as supplier administrator
Y/N Table Edit
Default Value: N
|
| 17 |
ROW_CREATE_DATE |
DateTime(26) |
TIMESTAMP |
Row Creation Date Time
Default Value: %DateTime
|
| 18 |
ROW_MODIFY_DATE |
DateTime(26) |
TIMESTAMP |
Modified Date Time
Default Value: %DateTime
|
| 19 |
ROW_CREATE_USER |
Character(30) |
VARCHAR2(30) NOT NULL |
Row Added By
|
| 20 |
ROW_MODIFY_USER |
Character(30) |
VARCHAR2(30) NOT NULL |
Modified User
|