PC_AM_PROJ_VW

(SQL View)
 Index Back

Project Costing Assets

Project Costing Assets. View of PC_AM_PROJ_DEFN used on secondary page, PC_AM_PROJ_DEFN_SEC.

SELECT A.BUSINESS_UNIT , A.PROJECT_ID , A.ACTIVITY_ID , A.ANALYSIS_TYPE , A.BUSINESS_UNIT_AM , A.ASSET_ID , A.ANALYSIS_GROUP , A.ANALYSIS_GROUP_RET , A.ANALYSIS_GROUP_AMR , A.INTFC_TYPE_RET , A.ASSET_ALLOC_PCT , A.DISTRIBUTION_PCT , A.DISTRIBUTION_AMT ,A.ASST_REVIEW_STATUS FROM PS_PC_AM_PROJ_DEFN A

# 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

2 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

Prompt Table: SP_PROJ5_NONVW

3 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID

Prompt Table: PC_AM_ACT_VW

4 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type

Prompt Table: PROJ_ANTYPE_TBL

5 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BU_AM_NONVW

6 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification

Prompt Table: PC_AM_DFNRUL_VW

7 ANALYSIS_GROUP Character(5) VARCHAR2(5) NOT NULL Analysis Group
8 ANALYSIS_GROUP_RET Character(5) VARCHAR2(5) NOT NULL Retirement Analysis Group
9 ANALYSIS_GROUP_AMR Character(5) VARCHAR2(5) NOT NULL Retire Proceed and Cost An Grp
10 INTFC_TYPE_RET Character(3) VARCHAR2(3) NOT NULL Retirement Interface Type
AAD=Additional Cost Add
ACQ=Insert Acquisition Detl
ADD=Asset Add
ADJ=Asset Cost Adjustment
ADQ=Adjust Cost & Acquisition Detl
ARA=Add Retired Assets
ASD=Asset Deletion
AUP=Asset Information Update
BKD=Book Deletion
BKS=Book Change
BSD=Selective Book Delete
CAP=Asset Capitalization
CIC=Capitalize Into Composite
CLC=Custodian/Location Change
CN1=Conversion of First Book
CN2=Conversion of Subsequent Books
FAD=Financial & Physical Add
IHI=Inventory History Insert
IUI=Inter-Unit Transfer In Side
IUO=Inter-Unit Transfer Out Side
LAD=Leased Asset Add
NAD=Non-Financial Add
OPT=Open Trans Generation
PHY=Physical Asset Change
PRT=Partial Retirement
RCT=Asset Recategorization
REI=Asset Reinstatement
RET=Asset Retirement
TRF=Intra-Business Unit Transfer
11 ASSET_ALLOC_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL Asset Allocation Percentage
12 DISTRIBUTION_PCT Number(7,3) DECIMAL(6,3) NOT NULL Distribution Percentage
13 DISTRIBUTION_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Distribution Amount
14 ASST_REVIEW_STATUS Character(1) VARCHAR2(1) NOT NULL Asset review status
A=Approved
D=Distributed
E=Reverse
H=Hold
N=New
R=Reject
V=Reversed

Default Value: A