RUN_GLRESET(SQL Table) |
Index Back |
---|---|
Run GLResetRun GLReset |
# | 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 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
3 | RUN_ID | Character(10) | VARCHAR2(10) NOT NULL |
Pay Run ID
Prompt Table: GL_GEN_HIST_VW |
4 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: GL_GEN_COMP_VW |
5 | PAYGROUP | Character(3) | VARCHAR2(3) NOT NULL |
Pay Group
Prompt Table: GL_GEN_PYGRP_VW |
6 | PAY_END_DT | Date(10) | DATE |
Pay Period End Date
Prompt Table: GL_GEN_DT_VW |
7 | RESET_DIST | Character(1) | VARCHAR2(1) NOT NULL |
Review Distribution before GL indicator.
Y/N Table Edit Default Value: Y |