PC_AM_MANCAP_VW

(SQL View)
 Index Back

PC AM Manual Capitalization

View used for manual capitalization

SELECT A.BUSINESS_UNIT , A.PROJECT_ID , A.ACTIVITY_ID , B.BUSINESS_UNIT_AM , B.ASSET_ID , B.DESCR , B.INTFC_TYPE , B.IN_SERVICE_DT FROM PS_PC_AM_PROJ_DEFN A , PS_PC_AM_DEFN B , PS_PC_AM_RULE_ACT C WHERE %Join(COMMON_KEYS, PC_AM_PROJ_DEFN A, PC_AM_DEFN B) AND %Join(COMMON_KEYS, PC_AM_PROJ_DEFN A, PC_AM_RULE_ACT C) AND B.AM_DISTRIB_STATUS <> 'I' AND C.PC_AM_CAP_SW = 'Y' AND ((B.INTFC_TYPE = 'FAD' AND C.PC_AM_INTG_TRIGGER = '1') OR (B.INTFC_TYPE <> 'FAD' AND C.PC_AM_ADJ_TRIGGER = '1'))

# 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 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
4 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit
5 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
7 INTFC_TYPE Character(3) VARCHAR2(3) NOT NULL Trans Load Type
8 IN_SERVICE_DT Date(10) DATE In Service Date