| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: PROJECT.BUSINESS_UNIT
Prompt Table:
SP_BU_PC_NONVW
|
| 2 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
Default Value: PROJECT.PROJECT_ID
Prompt Table:
PROJECT
|
| 3 |
ANALYSIS_GROUP |
Character(5) |
VARCHAR2(5) NOT NULL |
Analysis Group
Default Value: OPR_DEF_TBL_PC.ANALYSIS_GROUP
Prompt Table:
PROJ_AN_GRP_TBL
|
| 4 |
ANALYSIS_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Analysis Type
Prompt Table:
PC_ANGRP_VW
|
| 5 |
TRANS_DT |
Date(10) |
DATE NOT NULL |
Transaction Date
Default Value: %date
|
| 6 |
EFFSEQ |
Number(3,0) |
SMALLINT NOT NULL |
Effective Sequence
|
| 7 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 8 |
PROJ_FUND |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Project Funded Amount
|
| 9 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Default Value: BUS_UNIT_TBL_PC.CURRENCY_CD
Prompt Table:
CURRENCY_CD_TBL
Set Control Field: CURRENCY_CD
|
| 10 |
PC_FUND_FINALIZED |
Character(1) |
VARCHAR2(1) NOT NULL |
PC Fund Finalized
D=Distribute
E=Commitment Control Post Error
F=Finalized
K=Posted to Commitment Control
N=None
S=Security Error
Default Value: N
|
| 11 |
FINALIZE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Finalize
Y/N Table Edit
Default Value: N
|
| 12 |
PROJECT_ID_TO |
Character(15) |
VARCHAR2(15) NOT NULL |
Project ID To
Prompt Table:
PROJECT
|
| 13 |
POST_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Posting Option
Y/N Table Edit
Default Value: Y
|
| 14 |
PC_SEND_TO_KK |
Character(1) |
VARCHAR2(1) NOT NULL |
Push Button for Project Costing to Commitment Control
Y/N Table Edit
Default Value: N
|