PC_AM_EXP5_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.ACTIVITY_ID , 'CLS' , B.BUSINESS_UNIT_AM , B.ASSET_ID , 0 , 'U' , 'U' , A.DISTRIBUTION_PCT ,%subrec(PC_AM_PDEFN_SBR, A) ,%subrec(PC_AM_DEFN_SBR, B) 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'

  • Related Language Record: PC_AM_EXP45_LVW

    • # 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 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type
    5 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit

    Default Value: PC_INT_TMPL.BUSINESS_UNIT_AM

    Prompt Table: SP_BU_AM_NONVW

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

    Default Value: NEXT

    Prompt Table: PC_AM_DFNEXP_VW

    7 ROW_NUMBER_5 Number(5,0) INTEGER NOT NULL Row Number

    Default Value: 0

    8 DEFN_FLAG Character(1) VARCHAR2(1) NOT NULL Definition Flag

    Default Value: I

    9 PROJ_DEFN_FLAG Character(1) VARCHAR2(1) NOT NULL Project Definition Flag

    Default Value: I

    10 DISTRIBUTION_PCT Number(7,3) DECIMAL(6,3) NOT NULL Distribution Percentage
    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
    15 PROFILE_ID Character(10) VARCHAR2(10) NOT NULL Asset Profile ID

    Prompt Table: PROFILE_PCAM_VW
    Set Control Field: BUSINESS_UNIT_AM

    16 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    17 TAG_NUMBER Character(12) VARCHAR2(12) NOT NULL Tag Number
    18 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

    Prompt Table: LOCATION_TBL
    Set Control Field: BUSINESS_UNIT_AM

    19 CATEGORY Character(5) VARCHAR2(5) NOT NULL Asset Category

    Prompt Table: CATEGORY_TBL
    Set Control Field: BUSINESS_UNIT_AM

    20 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
    21 MANUFACTURER Character(60) VARCHAR2(60) NOT NULL Manufacturer Name

    Prompt Table: MANUF_FS_VW
    Set Control Field: BUSINESS_UNIT_AM

    22 GROUP_ASSET_ID Character(12) VARCHAR2(12) NOT NULL Group Asset ID

    Prompt Table: PC_AM_GROUP_VW

    23 PARENT_ID Character(12) VARCHAR2(12) NOT NULL Parent ID

    Prompt Table: PARENT_ASSET_VW

    24 PARENT_DESCR Character(30) VARCHAR2(30) NOT NULL Parent Asset Description
    25 PARENT_ASSET_SW Character(1) VARCHAR2(1) NOT NULL Parent Asset
    N=No
    Y=Yes

    Default Value: N

    26 QUANTITY Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Interface

    Default Value: 1

    27 IN_SERVICE_DT Date(10) DATE In Service Date

    Default Value: %DATE

    28 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: %EDIT_DEPT
    Set Control Field: BUSINESS_UNIT_AM

    29 ASSET_OPTION Character(3) VARCHAR2(3) NOT NULL Asset Creation Option
    ADD=Auto Assign New Asset ID
    ADJ=Adjust Existing Asset
    MAN=Manually Assign Asset ID

    Default Value: MAN

    30 INTFC_STATUS Character(3) VARCHAR2(3) NOT NULL Interface Status
    CON=Consolidated
    DON=Mass Changes Generated
    ERR=Error
    NEW=Mass Changes Not Generated
    REP=Replaced by Other Records (AP)
    UNI=Unitized

    Default Value: NEW

    31 INTFC_TYPE Character(3) VARCHAR2(3) NOT NULL Trans Load Type
    32 BOOK_PROCESSING_SW Character(1) VARCHAR2(1) NOT NULL Enable Book Processing
    N=No
    Y=Yes

    Default Value: N

    33 GROUP_ASSET_FLAG Character(1) VARCHAR2(1) NOT NULL Group Asset Flag
    G=Group Asset
    M=Group Member
    N=None
    34 LOCATION_EFFDT Date(10) DATE Location Effective Date
    35 TRANS_DT Date(10) DATE Transaction Date

    Default Value: %DATE

    36 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple

    Default Value: %DATE

    37 BOOK_EFFDT Date(10) DATE Book Effective Date
    38 TAGGABLE_SW Character(1) VARCHAR2(1) NOT NULL Taggable Asset
    N=Non Taggable Asset
    Y=Taggable Asset
    39 DEFAULT_PROFILE_SW Character(1) VARCHAR2(1) NOT NULL Default Books from Profile

    Default Value: Y

    40 OPEN_TRANS_ID Number(10,0) DECIMAL(10) NOT NULL Open Transaction ID
    41 AM_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL AM Distribution Status
    D=Distributed
    I=Ignore
    M=Modified
    N=Not Distributed
    P=Pending
    V=Reversed

    Default Value: N

    42 REPLACE_SW Character(1) VARCHAR2(1) NOT NULL Replacement Asset

    Default Value: N

    43 ACQUISITION_CD Character(1) VARCHAR2(1) NOT NULL Acquisition Code
    C=Constructed
    D=Donated
    I=Trade In
    K=Like Exchange
    L=Leased
    P=Purchased
    T=Transferred

    Default Value: C

    44 LOAD_STATUS Character(3) VARCHAR2(3) NOT NULL /* -> JMZ. PSOFT. 11-OCT-2002 */ New Status were added : HLD and INP for Asset Management. /* <- JMZ. PSOFT. 11-OCT-2002 */
    CON=Consolidated
    DON=Loaded
    ERR=Errored
    EXC=Excluded
    HLD=On Hold
    INP=In Process
    NEW=Pending
    PGI=PO Grp Incomplete
    REP=Replaced
    UNI=Unitized

    Default Value: NEW

    45 SYSTEM_SOURCE Character(3) VARCHAR2(3) NOT NULL Identifies the application or source system that generated a journal entry. Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values. SUJ---Included a label as Product. Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen.

    Default Value: BPC

    46 APPROVAL_SW Character(1) VARCHAR2(1) NOT NULL Auto Approval Status

    Default Value: Y

    47 DISPOSAL_CODE Character(1) VARCHAR2(1) NOT NULL Retirement Type
    A=Abandonment
    C=Cannibalize for Other Assets
    D=Disappeared Assets
    E=Expensed
    F=Disposal Due to Theft
    I=Returned to Inventory
    L=Like Kind Exchange
    M=Missing Asset
    N=Donated to External Group
    O=ARO Settlement
    R=Scrapped Assets
    S=Retirement by Sale
    T=Traded In for another Asset
    V=Auto-Retire Fully Depr Assets
    Y=Casualty Loss

    Default Value: S

    48 RETIREMENT_TYPE Character(1) VARCHAR2(1) NOT NULL Retirement Type
    E=Extraordinary
    O=Ordinary Retirement

    Default Value: O

    49 RETIREMENT_STATUS Character(1) VARCHAR2(1) NOT NULL Retirement Status
    C=Depreciation Calculated
    N=New Retirement
    P=Posted to General Ledger
    R=Reinstated Retirement
    U=No Retirements Exist

    Default Value: U