GPNZ_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: GPNZ_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 GPNZ_GLCALC_TS DateTime(26) TIMESTAMP This is the date/time when GL Calc process is run. This process needs to be run before Leave Entitlement can be processed.
    4 GPNZ_LVEENT_TS DateTime(26) TIMESTAMP This is the date/time that the Leave Entitlement process is run. It is used to determine if rerun is possible. If timestamp is earlier than GL Calc timestamp, the calculation needs to be re-run first.
    5 GPNZ_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
    7 GPNZ_LEAVE_IND Character(1) VARCHAR2(1) NOT NULL Check box that users select to run Leave Entitlement process.
    8 GPNZ_CHART_REMAP Character(1) VARCHAR2(1) NOT NULL Check box that users select to run Australian GL Chart Field remapping process.