INTFC_PC_TIM_VW

(SQL View)
 Index Back

Interface Timeline View


SELECT INTFC_ID ,INTFC_LINE_NUM ,BUSINESS_UNIT ,PROJECT_ID ,INTFC_TYPE ,SYSTEM_SOURCE ,APPROVAL_SW ,INTFC_STATUS ,LOAD_STATUS ,ORIG_INTFC_ID ,ORIG_LINE_NUM ,INTEGRATION_TMPL ,DESCR ,PROJECT_TYPE ,BUSINESS_UNIT_AM ,ASSET_ID ,PROFILE_ID ,TEMPLATE_ID ,TEMPLATE_SW ,AFUDC_PROJ_SW ,TARGET_PROJ_SW ,SALES_TAX_PROJ_SW ,DOCKET_NUMBER ,PROJECT_FUNCTION ,DTTM_STAMP ,OPRID ,DESCR254 ,ADDRESS_ID ,LOCATION_EFFDT ,EFFSEQ ,LOCATION ,LOCATION_FRACTION ,CNTRCT_ID ,CUST_ID ,PS_OWNER ,FLEX_FORMULA ,TEAM_MEMBER ,MANAGER_EFFDT ,PROJECT_MANAGER ,ROLE_TYPE ,MANAGER_START_DT ,MANAGER_END_DT ,STATUS_EFFDT ,PROJECT_STATUS ,START_DT ,END_DT ,PROJECT_PRIORITY ,PERCENT_COMPLETE ,INTEREST_FACTOR ,MILESTONE_EFFDT ,MILESTONE_TYPE ,MILESTONE_CODE ,MILESTONE_ORIGIN ,TRANS_DT ,ACCOUNTING_DT ,SCHEDULE_TYPE ,SCHEDULE_STATUS ,SCHEDULE_DESCR ,FROM_DT ,TO_DT ,DOCUMENT_TYPE ,DOCUMENT_NAME ,DOCUMENT_PATH ,PROJECT_USER1 ,PROJECT_USER2 ,PROJECT_USER3 ,PROJECT_USER4 ,PROJECT_USER5 ,SUMMARY_PRJ FROM PS_INTFC_PC_TIMEL

  • Parent record: PROJ_ACTIVITY

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INTFC_ID Number(8,0) INTEGER NOT NULL Interface ID
    2 INTFC_LINE_NUM Number(8,0) INTEGER NOT NULL Interface Line Number
    3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: SP_BU_PC_NONVW

    4 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
    5 INTFC_TYPE Character(3) VARCHAR2(3) NOT NULL Trans Load Type
    6 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.
    7 APPROVAL_SW Character(1) VARCHAR2(1) NOT NULL Auto Approval Status
    8 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
    9 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
    10 ORIG_INTFC_ID Number(8,0) INTEGER NOT NULL Original Interface ID
    11 ORIG_LINE_NUM Number(8,0) INTEGER NOT NULL Original Interface Line Number
    12 INTEGRATION_TMPL Character(15) VARCHAR2(15) NOT NULL Integration

    Prompt Table: PC_INT_TMPL

    13 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    14 PROJECT_TYPE Character(5) VARCHAR2(5) NOT NULL Project Type
    A=Activity
    G=Grant
    H=Phase
    P=Project
    S=Segment

    Prompt Table: PROJ_TYPE_TBL

    15 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit

    Prompt Table: SP_BU_AM_NONVW

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

    Prompt Table: PROJ_ASSET_VW

    17 PROFILE_ID Character(10) VARCHAR2(10) NOT NULL Asset Profile ID

    Prompt Table: PROFILE_PCAM_VW

    18 TEMPLATE_ID Character(30) VARCHAR2(30) NOT NULL Project Template

    Prompt Table: PROJECT_TMPL_VW

    19 TEMPLATE_SW Character(1) VARCHAR2(1) NOT NULL Allows the user to indicate whether a given bank transfer transaction should be designated as a
    20 AFUDC_PROJ_SW Character(1) VARCHAR2(1) NOT NULL Allow Interest Calculation
    21 TARGET_PROJ_SW Character(1) VARCHAR2(1) NOT NULL Allocation Target
    22 SALES_TAX_PROJ_SW Character(1) VARCHAR2(1) NOT NULL Allow Sales Tax Calculation
    23 DOCKET_NUMBER Character(15) VARCHAR2(15) NOT NULL Docket Number
    24 PROJECT_FUNCTION Character(10) VARCHAR2(10) NOT NULL Project Function
    25 DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    26 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    27 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    28 ADDRESS_ID Character(3) VARCHAR2(3) NOT NULL Address ID
    29 LOCATION_EFFDT Date(10) DATE Location Effective Date
    30 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
    31 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
    32 LOCATION_FRACTION Number(4,2) DECIMAL(3,2) NOT NULL Fraction of Cost at Location
    33 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
    34 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
    35 PS_OWNER Character(2) VARCHAR2(2) NOT NULL PeopleSoft Owner
    AM=Asset Management
    AP=Accounts Payable
    AR=Accounts Receivable
    BD=Budgets
    BI=Billing
    CA=Contracts
    CM=Cost Management
    CS=Customer Service
    EN=Engineering
    EX=Expenses
    GL=General Ledger
    HR=Human Resources
    IN=Inventory
    MG=Manufacturing
    OM=Order Management
    PC=Project Costing
    PL=Planning
    PO=Purchasing
    PR=Production Control
    PT=PeopleTools
    TL=Time and Labor
    TR=Treasury
    36 FLEX_FORMULA Character(15) VARCHAR2(15) NOT NULL Formula Name
    37 TEAM_MEMBER Character(30) VARCHAR2(30) NOT NULL Team Member
    38 MANAGER_EFFDT Date(10) DATE Project Manager Effective Date
    39 PROJECT_MANAGER Character(11) VARCHAR2(11) NOT NULL Project Manager
    40 ROLE_TYPE Character(6) VARCHAR2(6) NOT NULL Service Type
    APR=Approver
    MGR=Manager
    OPR=Operator
    41 MANAGER_START_DT Date(10) DATE Project Manager Start Date
    42 MANAGER_END_DT Date(10) DATE Project Manager End Date
    43 STATUS_EFFDT Date(10) DATE Project Status Effective Date
    44 PROJECT_STATUS Character(1) VARCHAR2(1) NOT NULL Project Status
    B=Budgeted
    C=Closed
    H=Hold
    O=Open
    P=Proposed
    45 START_DT Date(10) DATE Start Date
    46 END_DT Date(10) DATE End Date
    47 PROJECT_PRIORITY Number(3,0) SMALLINT NOT NULL Project Priority
    48 PERCENT_COMPLETE Number(6,2) DECIMAL(5,2) NOT NULL % Complete
    49 INTEREST_FACTOR Signed Number(5,2) DECIMAL(3,2) NOT NULL Interest Calculation Factor
    50 MILESTONE_EFFDT Date(10) DATE Milestone Effective Date
    51 MILESTONE_TYPE Character(5) VARCHAR2(5) NOT NULL Milestone Type
    52 MILESTONE_CODE Character(15) VARCHAR2(15) NOT NULL Milestone Code
    53 MILESTONE_ORIGIN Character(1) VARCHAR2(1) NOT NULL Milestone Origin
    A=Project
    C=Contract
    54 TRANS_DT Date(10) DATE Transaction Date
    55 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
    56 SCHEDULE_TYPE Character(15) VARCHAR2(15) NOT NULL Phase Type
    57 SCHEDULE_STATUS Character(1) VARCHAR2(1) NOT NULL Schedule Status
    A=Actual Schedule
    E=Estimated Schedule
    58 SCHEDULE_DESCR Character(30) VARCHAR2(30) NOT NULL Project Schedule Description
    59 FROM_DT Date(10) DATE From Date
    60 TO_DT Date(10) DATE To Date
    61 DOCUMENT_TYPE Character(3) VARCHAR2(3) NOT NULL Document Type
    123=Lotus 1-2-3
    AVI=Video for Windows
    CAD=AutoCad Document
    DOC=Microsoft Winword
    MPP=MicroSoft Project
    NON=No Document Type
    PST=PeopleSoft PeopleTools
    SCR=Lotus ScreenCam
    TLP=TimeLine for Windows
    TXT=Notepad for ASCII Text
    XLS=Microsoft Excel
    62 DOCUMENT_NAME Character(30) VARCHAR2(30) NOT NULL Document Path and Name
    63 DOCUMENT_PATH Character(80) VARCHAR2(80) NOT NULL Application Path
    64 PROJECT_USER1 Character(10) VARCHAR2(10) NOT NULL Project User 1
    65 PROJECT_USER2 Character(10) VARCHAR2(10) NOT NULL Project User 2
    66 PROJECT_USER3 Character(10) VARCHAR2(10) NOT NULL Project User 3
    67 PROJECT_USER4 Character(10) VARCHAR2(10) NOT NULL Project User 4
    68 PROJECT_USER5 Character(10) VARCHAR2(10) NOT NULL Project User 5
    69 SUMMARY_PRJ Character(1) VARCHAR2(1) NOT NULL An indicator to determine whether project is summary or detail.
    N=Detail Project
    Y=Program