PC_CPY_ACAM_TAO

(SQL Table)
Index Back

PC/AM Act Integration Rules

Activity level integration rules for the projects to assets integration.

  • Parent record: PC_AM_RULE_PRJ
  • # 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 PC_CPY_UNIQUEID Character(15) VARCHAR2(15) NOT NULL Copy Unique ID
    5 PC_AM_CAP_SW Character(1) VARCHAR2(1) NOT NULL Enable Integration
    N=No
    Y=Yes
    6 FILTER_ID Character(10) VARCHAR2(10) NOT NULL Filter criteria identification

    Prompt Table: PC_AM_FLTR

    7 FILTER_DTTM DateTime(26) TIMESTAMP Filter date time stamp
    8 PC_AM_LOC_SOURCE Character(2) VARCHAR2(2) NOT NULL Asset Location Source
    1=Asset Definition
    2=Activity
    9 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
    10 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
    11 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
    12 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
    13 IN_SERVICE_DT Date(10) DATE In Service Date
    14 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

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

    Prompt Table: PROJ_STATUS_TBL

    16 PROJ_PCT_COMPLETE Number(6,2) DECIMAL(5,2) NOT NULL Project Percent Complete
    17 ACT_PCT_COMPLETE Number(6,2) DECIMAL(5,2) NOT NULL Percent Complete
    18 PC_AM_ADJ_TRIGGER Character(2) VARCHAR2(2) NOT NULL Asset Adjustment Trigger
    1=Manual Capitalization Review
    2=Automatic
    19 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
    20 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
    21 DAY_OF_MONTH Number(2,0) SMALLINT NOT NULL Day of the Month
    22 INTFC_TYPE Character(3) VARCHAR2(3) NOT NULL Trans Load Type
    23 PC_AM_RET_TRIGGER Character(2) VARCHAR2(2) NOT NULL Retirement Trigger
    1=Manual
    2=Automatic
    24 RUN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL Run Process Flag

    Y/N Table Edit

    Default Value: Y

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

    Default Value: 1

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

    Prompt Table: PC_SUMMARY_PROJ