| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_PC.BUSINESS_UNIT
Prompt Table:
SP_BU_PC_NONVW
Set Control Field: BUSINESS_UNIT
|
| 2 |
USER_ORDER_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
User Order Type
Prompt Table:
FO_ORDER_TYPE
|
| 3 |
INTEGRATION_TMPL |
Character(15) |
VARCHAR2(15) NOT NULL |
Integration
Prompt Table:
PC_INT_TMPL
Set Control Field: BUSINESS_UNIT
|
| 4 |
PROJECT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Project Type
A=Activity
G=Grant
H=Phase
P=Project
S=Segment
Prompt Table:
PROJ_TYPE_TBL
Set Control Field: BUSINESS_UNIT
|
| 5 |
ENFORCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Enforce project team based prompt. Besides the defined translate values, this field is updated with a value of 'N' when team is not enforced in any of the products.
E=Expenses
N=No
T=Time&Labor
Y=Exp and TL
Default Value: T
|
| 6 |
ENFORCE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Enforce project and activity team based prompt.
B=Project and Activity Team
N=Do Not Enforce
P=Project Team Only
R=Project Resource Pools Only
S=Project Activity Resource Pool
X=Decide at the Project Level
Default Value: B
|
| 7 |
PROJECT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Project Status
B=Budgeted
C=Closed
H=Hold
O=Open
P=Proposed
Prompt Table:
PROJ_STATUS_TBL
|
| 8 |
ACTIVITY_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Activity Type
A=Activity Type
E=Entry Type
G=Group Type/Origin
O=Activity Type/Origin
R=Entry Type/Reason
Prompt Table:
PROJ_ACT_TBL
Set Control Field: BUSINESS_UNIT
|
| 9 |
PROJ_ROLE |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Role
Prompt Table:
PROJ_ROLE
Set Control Field: BUSINESS_UNIT
|
| 10 |
ACTIVITY_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Activity Status
Prompt Table:
PROJ_STATUS_TBL
|
| 11 |
EMPL_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Employee Type
E=Exception Hourly
H=Hourly
N=Not Applicable
S=Salaried
|
| 12 |
TAX_LOCATION_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Tax Location Code
Prompt Table:
FO_TAX_LOC_VW
|
| 13 |
FO_USE_EE_DEPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Employee Department
N=No
Y=Yes
Default Value: N
|
| 14 |
FO_USE_EMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Employee Time Enrollment
N=No
Y=Yes
Default Value: N
|