GPSG_GL_TS

(SQL Table)
 Index Back

Timestamps for GL processes

This table stores the dates and times when GL Calc and Leave Entitlement are run. The dates are used to prevent users from running a Leave Entitlement process without processing GL Calc first.

  • Parent record: GPSG_RC_GL_PREP

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
    2 STRM_NUM Number(4,0) SMALLINT NOT NULL Stream Number
    3 GPSG_GLCALC_TS DateTime(26) TIMESTAMP GL Calc process timestamp
    4 GPSG_LVEENT_TS DateTime(26) TIMESTAMP Leave Entitlement Timestamp
    5 GPSG_CHARTREMAP_TS DateTime(26) TIMESTAMP Date/time GL Chartfield remap process was run
    6 RUN_CALC_IND Character(1) VARCHAR2(1) NOT NULL Calculate Payees

    Y/N Table Edit

    7 GPSG_LEAVE_IND Character(1) VARCHAR2(1) NOT NULL Check box that users select to run Leave Entitlement process.

    Y/N Table Edit

    8 GPSG_CHART_REMAP Character(1) VARCHAR2(1) NOT NULL Check box that users select to run Australian GL Chart Field remapping process.

    Y/N Table Edit