PC_AM_ACT3_VW

(SQL View)
 Index Back

PC AM Exp: Express view

Views combination of activity level rules, asset definition and the relationship between assets and a project.

SELECT A.BUSINESS_UNIT , A.PROJECT_ID , A.BUSINESS_UNIT_AM , A.ASSET_ID , A.ACTIVITY_ID , 'Y' , 'CLS' , 'U' , A.BUSINESS_UNIT_AM , A.ASSET_ID , %subrec(PC_AM_PDEFN_SBR, A) FROM PS_PC_AM_PROJ_DEFN A , PS_PC_AM_DEFN B WHERE %Join(COMMON_KEYS, PC_AM_PROJ_DEFN A, PC_AM_DEFN B) AND B.AM_DISTRIB_STATUS <> 'I'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
3 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit
4 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
5 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
6 INCLUDE_ACT_SW Character(1) VARCHAR2(1) NOT NULL Include this Activity
N=No
Y=Yes
7 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type
8 PROJ_DEFN_FLAG Character(1) VARCHAR2(1) NOT NULL Project Definition Flag
9 BUSINESS_UNIT_FROM Character(5) VARCHAR2(5) NOT NULL Business Unit From
10 ASSET_ID_FROM Character(12) VARCHAR2(12) NOT NULL From Asset ID
11 ANALYSIS_GROUP Character(5) VARCHAR2(5) NOT NULL Analysis Group
12 ANALYSIS_GROUP_AMR Character(5) VARCHAR2(5) NOT NULL Retire Proceed and Cost An Grp
13 ANALYSIS_GROUP_RET Character(5) VARCHAR2(5) NOT NULL Retirement Analysis Group
14 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