GPMY_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: GPMY_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 GPMY_GLCALC_TS DateTime(26) TIMESTAMP GL Calc process timestamp
    4 GPMY_LVEENT_TS DateTime(26) TIMESTAMP Leave Entitlement Timestamp
    5 GPMY_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 GPMY_LEAVE_IND Character(1) VARCHAR2(1) NOT NULL Check box that users select to run Leave Entitlement process.

    Y/N Table Edit

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

    Y/N Table Edit