| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table:
OPRID_VW
|
| 2 |
POSTING_MODE |
Character(1) |
VARCHAR2(1) NOT NULL |
Posting Mode
C=Now on Client
L=Process Later
S=Now on Server
|
| 3 |
SERVER_NAME |
Character(8) |
VARCHAR2(8) NOT NULL |
Server Name
Prompt Table:
SERVERDEFN
|
| 4 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
Prompt Table:
RUN_CNTL_PC
|
| 5 |
TREE_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Tree SetID
Prompt Table:
SETID_TBL
|
| 6 |
TREE_NAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Tree Name
Prompt Table:
PROJ_TREE_VW
|
| 7 |
TREE_EFFDT |
Date(10) |
DATE |
Effective date of the Tree
Prompt Table:
PC_TREE_EFDT_VW
|
| 8 |
PARENT_NODE |
Character(20) |
VARCHAR2(20) NOT NULL |
Parent Tree Node
Prompt Table:
PC_TREE_NODE_VW
|
| 9 |
ANALYSIS_GROUP |
Character(5) |
VARCHAR2(5) NOT NULL |
Analysis Group
Prompt Table:
SP_AN_GRP_NONVW
|
| 10 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table:
SP_PROJ_NONVW
|
| 11 |
TEMPLATE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Project Template
Prompt Table:
PROJECT_TMPL_VW
|
| 12 |
OPEN_TRANS_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Open Transaction ID
Default Value: 1
|
| 13 |
OP_TRNS_ID_INCR_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Increment Depr Request ID Flag
N=Do Not Increment Depr Req ID
Y=Increment Depr Request ID
Default Value: Y
|
| 14 |
RATE_OPTION |
Character(3) |
VARCHAR2(3) NOT NULL |
Rate Option
ABI=Activity Bill Rate
ACO=Activity Cost Rate
AML=Mark Up/Down Labor
AMN=Mark Up/Down Non-labor
AMT=Quantity Rate
CRB=Custom Bill Rate
CRC=Custom Cost Rate
EBI=Employee Bill Rate
ECO=Employee Cost Rate
FIX=Fixed Amount
JBI=Job Code Bill Rate
JCO=Job Code Cost Rate
MUP=Markup Rate
NON=Bill at Cost
RBI=Project Role Bill Rate
RCO=Project Role Cost Rate
TBI=MM Tools Usage Bill Rate
TCO=MM Tools Usage Cost Rate
WBI=Work Order Labor Bill Rate
WCO=Work Order Labor Cost Rate
Default Value: MUP
|
| 15 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Default Value: USD
Prompt Table:
CURRENCY_CD_TBL
|
| 16 |
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.
Default Value: CRRNT
Prompt Table:
RT_TYPE_TBL
|
| 17 |
UNIT_OF_MEASURE |
Character(3) |
VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
Default Value: MHR
Prompt Table:
UNITS_TBL
|
| 18 |
TRANS_DT |
Date(10) |
DATE |
Transaction Date
|
| 19 |
ACCOUNTING_DT |
Date(10) |
DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
|
| 20 |
FROM_DATE |
Date(10) |
DATE |
From Date
|
| 21 |
THRU_DATE |
Date(10) |
DATE |
Through Date
|
| 22 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SP_BU_PC_NONVW
|
| 23 |
BUSINESS_UNIT_PO |
Character(5) |
VARCHAR2(5) NOT NULL |
PO Business Unit
Prompt Table:
SP_BU_PM_NONVW
|
| 24 |
BUSINESS_UNIT_AP |
Character(5) |
VARCHAR2(5) NOT NULL |
AP Business Unit
Prompt Table:
SP_BU_AP_NONVW
|
| 25 |
BUSINESS_UNIT_AM |
Character(5) |
VARCHAR2(5) NOT NULL |
AM Business Unit
Prompt Table:
SP_BU_AM_NONVW
|
| 26 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
Prompt Table:
SP_BU_GL_NONVW
|
| 27 |
BUSINESS_UNIT_BD |
Character(5) |
VARCHAR2(5) NOT NULL |
Budgeting Business Unit
Prompt Table:
SP_BUPCBD_NONVW
|
| 28 |
BUSINESS_UNIT_OM |
Character(5) |
VARCHAR2(5) NOT NULL |
Order Management Business Unit
Prompt Table:
SP_BUPCOM_NONVW
|
| 29 |
BUSINESS_UNIT_BI |
Character(5) |
VARCHAR2(5) NOT NULL |
Billing Business Unit
Prompt Table:
SP_BU_BI_NONVW
|
| 30 |
BUSINESS_UNIT_AR |
Character(5) |
VARCHAR2(5) NOT NULL |
AR Business Unit
Prompt Table:
SP_BUARED_NONVW
|
| 31 |
BUSINESS_UNIT_IN |
Character(5) |
VARCHAR2(5) NOT NULL |
Inventory Unit
Prompt Table:
SP_BUIN_NONVW
|
| 32 |
INTEGRATION_TMPL |
Character(15) |
VARCHAR2(15) NOT NULL |
Integration
Prompt Table:
PC_INT_TMPL
|
| 33 |
DOCUMENT_DRIVE |
Character(5) |
VARCHAR2(5) NOT NULL |
Document Drive
|
| 34 |
DOCUMENT_PATH |
Character(80) |
VARCHAR2(80) NOT NULL |
Application Path
|
| 35 |
DOCUMENT_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Document Path and Name
|
| 36 |
MILESTONE_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Milestone Type
Default Value: PCT
|
| 37 |
TEAM_MEMBER |
Character(30) |
VARCHAR2(30) NOT NULL |
Team Member
Prompt Table:
PROJ_TEAM_VW
|
| 38 |
FLEX_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Flexible Formula Setid
Prompt Table:
SETID_TBL
|
| 39 |
FLEX_TEMPLATE_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Flexible Analysis Template
Prompt Table:
PC_FLEX_TEM_DVW
|
| 40 |
PC_EDIT_PRJ_OPT |
Character(4) |
VARCHAR2(4) NOT NULL |
Edit Project List Option
BYBU=By Business Unit
BYTR=By Project Tree
|
| 41 |
FLEX_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID
Default Value: OPR_DEF_TBL_PC.OPRID
Prompt Table:
OPRID_VW
|
| 42 |
MY_PRJ_MANUAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Y/N indicator for populating My Projects manually by the user.
Y/N Table Edit
|
| 43 |
MY_PRJ_SECURITY |
Character(1) |
VARCHAR2(1) NOT NULL |
Y/N indicator for populating My Projects using project security.
Y/N Table Edit
|
| 44 |
MY_PRJ_ALL |
Character(1) |
VARCHAR2(1) NOT NULL |
Y/N indicator for populating My Projects using project team.
Y/N Table Edit
|
| 45 |
MY_PRJ_TEAM |
Character(1) |
VARCHAR2(1) NOT NULL |
Y/N indicator for populating My Projects using project team.
Y/N Table Edit
|
| 46 |
MY_PRJ_TREE |
Character(1) |
VARCHAR2(1) NOT NULL |
Y/N indicator for populating My Projects using the default tree node from the user's preferences.
Y/N Table Edit
|
| 47 |
MY_PRJ_GRANTS |
Character(1) |
VARCHAR2(1) NOT NULL |
Y/N indicator for populating My Projects using the Grants Portal project level security.
Y/N Table Edit
|
| 48 |
MY_PRJ_INACTIVE |
Character(1) |
VARCHAR2(1) NOT NULL |
Y/N indicator for including inactive projects on users' My Projects lists.
Y/N Table Edit
|
| 49 |
MY_PRJ_OVERRIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
Y/N indicator that identifies whether the My Projects options have been overridden by the user.
Y/N Table Edit
|
| 50 |
MY_PRJ_REM_INACTIV |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicator to remove inactive projects from user's My Projects list.
Y/N Table Edit
|
| 51 |
PC_TOT_PER_QTY |
Number(10,0) |
DECIMAL(10) NOT NULL |
Total Period Quantity
Default Value: INSTALLATION_PC.PC_TOT_PER_QTY
|
| 52 |
BUSINESS_UNIT_WRK |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SP_BU_PC_NONVW
|
| 53 |
ACTIVE_RES_ONLY |
Character(1) |
VARCHAR2(1) NOT NULL |
Active Resources Only
N=No
Y=Yes
|
| 54 |
NUM_WEEKS |
Number(10,0) |
DECIMAL(10) NOT NULL |
Weeks Past Due
Default Value: 52
|