GPES_RC_FNQ1(SQL Table) |
Index Back |
|---|---|
Company certificate run cntlContains fields that are used as input parameters for company certificate report. Input data is retrieved from this record when a report is requested from the Process Scheduler. |
| # | 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 | RESPONSIBLE_ID | Character(11) | VARCHAR2(11) NOT NULL |
Responsible ID
Prompt Table: PERS_SRCH_GBL |
| 4 | GPES_FROM_DT | Date(10) | DATE |
From date
Default Value: %DATE |
| 5 | GPES_EMPLOYEE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Employee Type
A=Active employees I=Terminated employees Default Value: A |
| 6 | GPES_TO_DT | Date(10) | DATE | To date |
| 7 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL |
Empl Record
Prompt Table: EMPLMT_SRCH_GBL |
| 8 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL |
Language Code
Default Value: ESP |
| 9 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL | Job Code |
| 10 | GPES_MULT_CONTRACT | Character(1) | VARCHAR2(1) NOT NULL |
Multiple Company Contract selection
Y/N Table Edit Default Value: N |
| 11 | GPES_BGN_DT_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Printing begin date option.
C=Last Contract H=First Hire R=Last Rehire Default Value: C |
| 12 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |