PC_AM_RULE_BU

(SQL Table)
 Index Back

PC/AM BU Integration Rules

Business Unitl level integration rules for the projects to assets integration.

  • Parent Record Of PC_AM_RULE_PRJ PC_CPY_PJAM_TAO

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 PC_AM_CAP_SW Character(1) VARCHAR2(1) NOT NULL Enable Integration
    N=No
    Y=Yes
    3 FILTER_ID Character(10) VARCHAR2(10) NOT NULL Filter criteria identification

    Prompt Table: PC_AM_FLTR

    4 FILTER_DTTM DateTime(26) TIMESTAMP Filter date time stamp
    5 PC_AM_LOC_SOURCE Character(2) VARCHAR2(2) NOT NULL Asset Location Source
    1=Asset Definition
    2=Activity
    6 PC_AM_RUN_OPTN Character(1) VARCHAR2(1) NOT NULL Asset Processing Destination
    B=Summarize and Run Interface
    D=Asset Integration Rule Default
    I=Run Interface
    L=Sum, Run and Load Transactions
    R=Run Interface and Load
    S=Summarize
    7 PC_AM_CAP_RULE Character(3) VARCHAR2(3) NOT NULL Asset Identification Rule
    1=Manual Identification
    2=One Asset Per Activity
    3=One Asset From Many Activities
    4=Many Assets to Many Activities
    5=Many Assets From Each Activity
    6=Derive From Work Order Task
    8 PC_AM_DISTRIB_RULE Character(2) VARCHAR2(2) NOT NULL Distribution Rule
    1=Project Percent Distribution
    2=Activity Percent Distribution
    3=Project Quantity Distribution
    4=Activity Quantity Distribution
    9 PC_AM_INTG_TRIGGER Character(2) VARCHAR2(2) NOT NULL Asset Creation Trigger
    1=Manual Capitalization Review
    2=Asset In Service Date
    3=Specified Date
    4=Project Status
    5=Activity Status
    6=Project Percent Complete
    7=Activity Percent Complete
    10 IN_SERVICE_DT Date(10) DATE In Service Date
    11 PROJECT_STATUS Character(1) VARCHAR2(1) NOT NULL Project Status
    B=Budgeted
    C=Closed
    H=Hold
    O=Open
    P=Proposed

    Prompt Table: PROJ_STATUS_TBL

    12 ACTIVITY_STATUS Character(1) VARCHAR2(1) NOT NULL Activity Status

    Prompt Table: PROJ_STATUS_TBL

    13 PROJ_PCT_COMPLETE Number(6,2) DECIMAL(5,2) NOT NULL Project Percent Complete
    14 ACT_PCT_COMPLETE Number(6,2) DECIMAL(5,2) NOT NULL Percent Complete
    15 PC_AM_ADJ_TRIGGER Character(2) VARCHAR2(2) NOT NULL Asset Adjustment Trigger
    1=Manual Capitalization Review
    2=Automatic
    16 PC_AM_END_YR_RULE Character(2) VARCHAR2(2) NOT NULL End of Year Rule
    1=Ignore End of Year
    2=Create Parent/Child Assets
    3=Create New Asset
    4=Stop Sending Adjustments
    17 MONTHCD Character(2) VARCHAR2(2) NOT NULL Month
    01=01 - January
    02=02 - February
    03=03 - March
    04=04 - April
    05=05 - May
    06=06 - June
    07=07 - July
    08=08 - August
    09=09 - September
    10=10 - October
    11=11 - November
    12=12 - December
    18 DAY_OF_MONTH Number(2,0) SMALLINT NOT NULL Day of the Month
    19 INTFC_TYPE Character(3) VARCHAR2(3) NOT NULL Trans Load Type
    20 PC_AM_RET_TRIGGER Character(2) VARCHAR2(2) NOT NULL Retirement Trigger
    1=Manual
    2=Automatic
    21 RUN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL Run Process Flag

    Y/N Table Edit

    Default Value: Y

    22 INTEGRATION_TYPE Character(1) VARCHAR2(1) NOT NULL Integration Type
    1=Capitalization
    2=Retirement

    Default Value: 1

    23 PROJECT_ID_2 Character(15) VARCHAR2(15) NOT NULL Project

    Prompt Table: PC_SUMMARY_PROJ