| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 2 |
PC_KEYS_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
BU, Project, Activity
O=Optional
R=Required
Default Value: O
|
| 3 |
PC_RES_TYPE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Source Type
O=Optional
R=Required
Default Value: O
|
| 4 |
PC_RES_CAT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Category
O=Optional
R=Required
Default Value: O
|
| 5 |
PC_RES_SUB_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
SubCategory
O=Optional
R=Required
Default Value: O
|
| 6 |
COMBO_EDIT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Edit Combinations
Y/N Table Edit
Default Value: N
|
| 7 |
PC_TLA_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Time and Labor Estimates
Y/N Table Edit
Default Value: N
|
| 8 |
PC_TLB_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Time and Labor for Billing
Y/N Table Edit
Default Value: N
|
| 9 |
RECON_BY |
Character(1) |
VARCHAR2(1) NOT NULL |
Used for the TL_TO_PC application engine
A=Reconcile by Amount
B=Both Quantity and Amount
N=Do not Reconcile
Q=Reconcile by Quantity
Default Value: N
|
| 10 |
PC_TLC_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Time and Labor Contractor
Y/N Table Edit
Default Value: N
|
| 11 |
PC_PAY_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Time and Labor Actuals
Y/N Table Edit
Default Value: N
|
| 12 |
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: N
|
| 13 |
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: N
|
| 14 |
PC_SUMMARY_LVL |
Character(1) |
VARCHAR2(1) NOT NULL |
Summary Level
A=BU, Project, Activity
C=Category
S=Subcategory
T=Source Type
Default Value: A
|
| 15 |
RESOURCE_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Source Type
Prompt Table:
PROJ_RES_TYPE
|
| 16 |
RESOURCE_CATEGORY |
Character(5) |
VARCHAR2(5) NOT NULL |
Category
Prompt Table:
%EDIT_RES_CAT
|
| 17 |
RESOURCE_SUB_CAT |
Character(5) |
VARCHAR2(5) NOT NULL |
Subcategory
Prompt Table:
%EDIT_RES_SUB
|
| 18 |
LEDGER_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger Group
Prompt Table:
SP_LEDGKK_NONVW
|
| 19 |
PC_KK_REQ_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
Requisition Source Type
Prompt Table:
KK_SOURCE_TRAN
|
| 20 |
PC_KK_PO_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
Purchase Order Source Type
Prompt Table:
KK_SOURCE_TRAN
|
| 21 |
WAIVED_FA_CLC_MTHD |
Character(1) |
VARCHAR2(1) NOT NULL |
This field allows a user to defined whether waived facilities and administrative costs are determined by subtracting the budgeted/funded amount from the institution amount or from the sponsor amount.
I=Institution Minus Funded
S=Sponsor Minus Funded
Default Value: I
|
| 22 |
PC_CALCULATE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Project-level switch to allow auto-calculation to be turned off if enabled at the BU level.
D=Delay Calculations Until Save
M=Manual
R=Realtime Calculations
|
| 23 |
PC_CALC_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Calculation Method
A=Budget Amount
D=Duration
F=Forecast Amount
H=Forecast Hours
M=Manual
U=Budget Hours
Default Value: M
|
| 24 |
PC_SUM_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Summary Method
N=None
S=Straight-Line
W=Weighted
Default Value: N
|
| 25 |
PC_HOURS_PER_DAY |
Number(2,0) |
SMALLINT NOT NULL |
Hours per Day
Default Value: 8
|
| 26 |
PC_DEFAULT_BUD_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Default Budget Item
|
| 27 |
PC_DEFAULT_ROLE |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Role
Prompt Table:
PROJ_ROLE
|
| 28 |
PC_CHC_TEMPLATE |
Character(30) |
VARCHAR2(30) NOT NULL |
Change Control Template
Prompt Table:
PC_CHC_CFG
|
| 29 |
FORECAST_AUT_APP |
Character(1) |
VARCHAR2(1) NOT NULL |
Automatic Forecast Approval
N=No
Y=Yes
|
| 30 |
FORECAST_LEVEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Forecast Level
A=Project/Activity
P=Project
Default Value: A
|
| 31 |
FORECAST_RATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Standard Rate
E=Resource
J=Job Code
R=Role
Default Value: R
|
| 32 |
FORECAST_SRC |
Character(1) |
VARCHAR2(1) NOT NULL |
Forecast Source
F=PeopleSoft Forecast Collection
M=3rd Party Microsoft Project
P=3rd Party Primavera
|
| 33 |
HOLIDAY_LIST_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
This is used to identify what holiday calendar to use. This is the access
field for all financials groups.
Default Value: 01
Prompt Table:
BUS_CAL_HOL_VW
|
| 34 |
PC_PRJ_DEF_CALC_MT |
Character(1) |
VARCHAR2(1) NOT NULL |
Calculate The
D=Duration
E=End Date
S=Start Date
Default Value: E
|
| 35 |
PC_ACT_DEF_CALC_MT |
Character(1) |
VARCHAR2(1) NOT NULL |
Activity Calculation Method
D=Duration
E=End Date
S=Start Date
Default Value: D
|
| 36 |
PGM_EPT_NAME |
Character(18) |
VARCHAR2(18) NOT NULL |
The name of the Enterprise Program Tree.
Prompt Table:
PC_BU_TREE_VW
|
| 37 |
PGM_SCHED_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
The method to be used for Project Scheduling. Valid methods are: Fixed Units, Fixed Duration, and Fixed Work
D=Fixed Duration
U=Fixed Units
W=Fixed Work
Default Value: U
|
| 38 |
CALENDAR_ID |
Character(2) |
VARCHAR2(2) NOT NULL |
Calendar ID
Prompt Table:
CAL_DETL_VW
|
| 39 |
CHARGING_LEVEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Project Charging Level - identifies which level of the WBS activities are available for charging.
'D' indicates the detail level, which means all detail activities are available for charging.
'1' indicates level 1 of the WBS is available for charging.
'2' indicates level 2 of the WBS is available for charging.
'3' indicates level 3 of the WBS is available for charging.
1=Costing Level 1
2=Costing Level 2
3=Costing Level 3
D=Detail
Default Value: D
|
| 40 |
CHARGING_LEVEL_TR |
Character(1) |
VARCHAR2(1) NOT NULL |
Time Report Charging Level - identifies which level of the WBS activities are available for charging on time reports enter in Expenses.
'D' indicates the detail level, which means all detail activities are available for charging.
'1' indicates level 1 of the WBS is available for charging.
'2' indicates level 2 of the WBS is available for charging.
'3' indicates level 3 of the WBS is available for charging.
1=Costing Level 1
2=Costing Level 2
3=Costing Level 3
D=Detail
Default Value: D
|
| 41 |
RATE_TYPES |
Character(1) |
VARCHAR2(1) NOT NULL |
Restrict Rate Types
Y/N Table Edit
Default Value: N
|
| 42 |
BILL_RATE_NAM_CUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Named Resource Bill Rate Type "Override"
Y/N Table Edit
Default Value: N
|
| 43 |
BILL_RATE_NAM_EMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Named Resource Bill Rate Type "Employee"
Y/N Table Edit
Default Value: N
|
| 44 |
BILL_RATE_NAM_JC |
Character(1) |
VARCHAR2(1) NOT NULL |
Named Resource Bill Rate Type "Job Code"
Y/N Table Edit
Default Value: N
|
| 45 |
BILL_RATE_NAM_PR |
Character(1) |
VARCHAR2(1) NOT NULL |
Named Resource Bill Rate Type "Project Role"
Y/N Table Edit
Default Value: N
|
| 46 |
BILL_RATE_GEN_CUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Generic Resource, Bill Rate Type "Override"
Y/N Table Edit
Default Value: N
|
| 47 |
BILL_RATE_GEN_PR |
Character(1) |
VARCHAR2(1) NOT NULL |
Generic Resource, Bill Rate Type "Project Role"
Y/N Table Edit
Default Value: N
|
| 48 |
COST_RATE_NAM_CUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Named Resource, Cost Rate Type "Override"
Y/N Table Edit
Default Value: N
|
| 49 |
COST_RATE_NAM_EMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Named Resource, Cost Rate Type "Employee"
Y/N Table Edit
Default Value: N
|
| 50 |
COST_RATE_NAM_JC |
Character(1) |
VARCHAR2(1) NOT NULL |
Named Resource, Cost Rate Type "Job Code"
Y/N Table Edit
Default Value: N
|
| 51 |
COST_RATE_NAM_PR |
Character(1) |
VARCHAR2(1) NOT NULL |
Named Resource, Cost Rate Type "Project Role"
Y/N Table Edit
Default Value: N
|
| 52 |
COST_RATE_GEN_CUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Generic Resource Override Cost Rate
Y/N Table Edit
Default Value: N
|
| 53 |
COST_RATE_GEN_PR |
Character(1) |
VARCHAR2(1) NOT NULL |
Generic Project Role Cost Rate
Y/N Table Edit
Default Value: N
|
| 54 |
MANAGER_ROLE |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Manager Role
Default Value: PROJ MANAGER
Prompt Table:
PROJ_ROLE
|
| 55 |
BUDGET_ITEM_REV |
Character(15) |
VARCHAR2(15) NOT NULL |
Revenue Budget Item
Default Value: REVEST
Prompt Table:
REV_BUD_ITEM_VW
|
| 56 |
RATE_DEF_COST |
Character(1) |
VARCHAR2(1) NOT NULL |
Rate Definition to track cost rates.
Default Value: Y
|
| 57 |
RATE_DEF_BIL |
Character(1) |
VARCHAR2(1) NOT NULL |
Rate Definition to track billing rates.
Default Value: Y
|
| 58 |
RATE_DEF_REV |
Character(1) |
VARCHAR2(1) NOT NULL |
Rate Definition to track revenue rates.
|
| 59 |
BUD_VER_HIS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag for enabling budget historical versioning
Y/N Table Edit
Default Value: N
|
| 60 |
DEF_GEN_BILL_RATE |
Character(1) |
VARCHAR2(1) NOT NULL |
New field added to hold Default Bill Rate Type for Generic Resources
C=Override Rate
R=Project Role Rate
Default Value: C
|
| 61 |
DEF_GEN_COST_RATE |
Character(1) |
VARCHAR2(1) NOT NULL |
New field added to hold Default Cost Rate Type for Generic Resources
C=Override Rate
R=Project Role Rate
Default Value: C
|
| 62 |
DEF_NAM_BILL_RATE |
Character(1) |
VARCHAR2(1) NOT NULL |
New field added to hold Default Bill Rate Type for Named Resources
C=Override Rate
E=Employee Rate
J=Jobcode Rate
R=Project Role Rate
X=Custom Rate
Default Value: C
|
| 63 |
DEF_NAM_COST_RATE |
Character(1) |
VARCHAR2(1) NOT NULL |
New field added to hold Default Cost Rate Type for Named Resources
C=Override Rate
E=Employee Rate
J=Jobcode Rate
R=Project Role Rate
X=Custom Rate
Default Value: C
|
| 64 |
RETAIN_HISTORY |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicator to determine how often history is retained.
D=Daily
M=Monthly
Q=Quarterly
W=Weekly
Default Value: W
|
| 65 |
P6_INSTANCE |
Character(30) |
VARCHAR2(30) NOT NULL |
Primavera P6 Instance with wich PeopleSoft integrates
|
| 66 |
P6_TEMPLATE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
P6 Synchronization Template Id
Prompt Table:
P6_SYNC_TMPLT
|
| 67 |
ACT_COST_EXP_LVL |
Character(1) |
VARCHAR2(1) NOT NULL |
Acttual Cost Export Level
A=Total
S=Source Type
|
| 68 |
AN_GRP_LABOR |
Character(5) |
VARCHAR2(5) NOT NULL |
Analysis Group identifying labor.
Prompt Table:
SP_AN_GRP_NONVW
|
| 69 |
EPS_NODE |
Character(30) |
VARCHAR2(30) NOT NULL |
Enterprise Project Node
|
| 70 |
WF_TIMEOUT_MINUTES |
Number(3,0) |
SMALLINT NOT NULL |
Timeout Minutes
|
| 71 |
RETAIN_COUNT |
Number(3,0) |
SMALLINT NOT NULL |
Project Instances to Retain
|
| 72 |
INTEGRATION_TMPL |
Character(15) |
VARCHAR2(15) NOT NULL |
Integration
Prompt Table:
PC_INT_TMPL
|
| 73 |
AN_GRP_COMMIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Analysis Group identifying labor.
Prompt Table:
SP_AN_GRP_NONVW
|
| 74 |
NUM_OF_LEVELS |
Number(3,0) |
SMALLINT NOT NULL |
Number of Levels
Default Value: 9
|
| 75 |
ONE_TARGET_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Group target definitions
N=No
Y=Yes
Y/N Table Edit
Default Value: INSTALLATION_PC.ONE_TARGET_SW
|
| 76 |
CONS_TPL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Contracts Console Template ID
Default Value: PROJECTS
Prompt Table:
CA_CONS_PCBU_VW
|
| 77 |
DEF_CRATE_COST |
Character(15) |
VARCHAR2(15) NOT NULL |
The default Custom Rate Name for costing rate
Prompt Table:
PC_CR_PRL_VW
|
| 78 |
DEF_CRATE_BILL |
Character(15) |
VARCHAR2(15) NOT NULL |
The default Custom Rate Name for billing rate
Prompt Table:
PC_CR_PRL_VW
|
| 79 |
BILL_RATE_NAME_X |
Character(1) |
VARCHAR2(1) NOT NULL |
An indicator for allowing Custom Bill Rates on the Project Resource LIst (PRL) and ARL.
Y/N Table Edit
|
| 80 |
COST_RATE_NAME_X |
Character(1) |
VARCHAR2(1) NOT NULL |
An indicator for allowing Custom Cost Rate on the PRL & ARL.
Y/N Table Edit
|
| 81 |
BUDGET_ITEM_LAB |
Character(15) |
VARCHAR2(15) NOT NULL |
Labor Budget Item
Prompt Table:
BUDGET_ITEM_LAB
|
| 82 |
BUDGET_ITEM_MAT |
Character(15) |
VARCHAR2(15) NOT NULL |
Material Budget Item
Prompt Table:
BUDGET_ITEM_MAT
|
| 83 |
BUDGET_ITEM_ASSET |
Character(15) |
VARCHAR2(15) NOT NULL |
Asset/Equipment Budget Item
Prompt Table:
BUDGET_ITEM_ASS
|
| 84 |
WAIT_FOR_GL_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag to indicate that transactions will not be integrated to PC until after they have been posted in GL.
Y/N Table Edit
Default Value: N
|