RUN_CNTL_ID10=Employee ID, Employee Rcd Nbr
20=Name, Employee Rcd Nbr
10=Q1
20=Q2
30=Q3
40=Q4
Prompt Table: GPIN_ESTAB_VW
Y/N Table Edit
Default Value: N
Default Value: %date
GPIN_24Q_RC(SQL Table) |
Index Back |
|---|---|
Form 24Q Runcontrol TableForm 24Q Runcontrol Parameter Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | GPIN_YEAR_CD | Character(4) | VARCHAR2(4) NOT NULL | Year-Character |
| 4 | BGN_DT | Date(10) | DATE | Begin Date |
| 5 | END_DT | Date(10) | DATE | end date |
| 6 | GP_GENRPT_SORT_OPT | Character(2) | VARCHAR2(2) NOT NULL |
Sort option for generic reports
10=Employee ID, Employee Rcd Nbr 20=Name, Employee Rcd Nbr |
| 7 | GPIN_QUARTER_ID | Character(2) | VARCHAR2(2) NOT NULL |
This field specifies which quarter of the year payment is being made
10=Q1 20=Q2 30=Q3 40=Q4 |
| 8 | ESTABID | Character(12) | VARCHAR2(12) NOT NULL |
Establishment ID
Prompt Table: GPIN_ESTAB_VW |
| 9 | GPIN_RPT_FILED_YN | Character(1) | VARCHAR2(1) NOT NULL |
This field specifies the report filed for the Quarter
Y/N Table Edit Default Value: N |
| 10 | GPIN_VCHR_NBR | Character(10) | VARCHAR2(10) NOT NULL | Voucher Number |
| 11 | CREATION_DT | Date(10) | DATE |
Creation Date
Default Value: %date |