CAL_RUN_IDSTRM_NUMY/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: N
GPMX_GL_TS(SQL Table) |
Index Back |
|---|---|
Timestamps for GL processesThis 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. |
| # | 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 | GPMX_GLCALC_TS | DateTime(26) | TIMESTAMP | Date/time that the GL Calculate process was run |
| 4 | GPMX_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 | GPMX_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 Default Value: N |
| 7 | GPMX_LEAVE_IND | Character(1) | VARCHAR2(1) NOT NULL |
Check box that users select to run Leave Entitlement process.
Y/N Table Edit Default Value: N |
| 8 | GPMX_CHART_REMAP | Character(1) | VARCHAR2(1) NOT NULL |
Check box that users select to run Mexican GL Chart Field remapping process.
Y/N Table Edit Default Value: N |