RUN_CNTL_P6_TIM

(SQL Table)
 Index Back

Primavera Time Import Runcntl

Run control record for importing Primavera timesheets to PeopleSoft.

  • Parent Record Of P6_TIME_DEPT P6_TIME_EMPLID P6_TIME_JOBCODE P6_TIME_LOC P6_TIME_POOL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 AE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name (see PSAEAPPLDEFN).
    3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
    4 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

    Prompt Table: SP_BU_GL_NONVW

    5 P6_INSTANCE Character(30) VARCHAR2(30) NOT NULL Primavera P6 Instance with wich PeopleSoft integrates

    Prompt Table: P6_INSTANCE_VW

    6 P6_TIME_SEND_TO Character(2) VARCHAR2(2) NOT NULL Indicator that determines where timesheet data from Primavera will be sent to (either Expenses or Project Costing).
    EX=Expenses
    PC=Project Costing
    7 P6_AND_OR_1 Character(3) VARCHAR2(3) NOT NULL P6 AND / OR Option
    AND=AND
    OR=OR

    Default Value: AND

    8 P6_AND_OR_2 Character(3) VARCHAR2(3) NOT NULL P6 And / Or Option
    AND=AND
    OR=OR

    Default Value: AND

    9 P6_TIME_PERIODS Character(1) VARCHAR2(1) NOT NULL Indicators of how many pay periods to process.
    1=Current Period
    2=Last 2 Periods
    3=Last 3 Periods
    4=Last 4 Periods
    5=Last 5 Periods
    10 P6_TIME_WEEKS Character(1) VARCHAR2(1) NOT NULL Indicators of how many weeks to process.
    1=Current Week
    2=Last 2 Weeks
    3=Last 3 Weeks
    4=Last 4 Weeks
    5=Last 5 Weeks
    6=Last 6 Weeks
    7=Last 7 Weeks
    8=Last 8 Weeks
    11 NUM_PERIODS Number(2,0) SMALLINT NOT NULL Number of Time Periods
    12 PERIOD_BEGIN_DT Date(10) DATE Period Begin Date
    13 PERIOD_END_DT Date(10) DATE Represents the date termination point for a given time set utilized in cash worksheet processing.
    14 BEGIN_DT Date(10) DATE Begin Date
    15 END_DT Date(10) DATE End Date