OPRIDPrompt Table: OPERATOR_VW
RUN_CNTL_IDPrompt Table: COMPANY_TBL
Prompt Table: ESTAB_TBL
Prompt Table: UNION_TBL
Default Value: %date
0010=Employer
0020=Employees
0040=Autonomous
Default Value: 0010
GPBR_RC_GRCS(SQL Table) |
Index Back |
|---|---|
GRCS Run ControlGRCS Run Control Union Contribution Guide |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: OPERATOR_VW |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
| 4 | ESTABID | Character(12) | VARCHAR2(12) NOT NULL |
Establishment ID
Prompt Table: ESTAB_TBL |
| 5 | UNION_CD | Character(3) | VARCHAR2(3) NOT NULL |
Union Code
Prompt Table: UNION_TBL |
| 6 | GPBR_YEAR_REFER | Character(4) | VARCHAR2(4) NOT NULL | Reference Year |
| 7 | GPBR_DUE_DATE | Date(10) | DATE |
Due Date
GRCS report
Default Value: %date |
| 8 | GPBR_GRCS_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Contribution Type
GRCS report
0010=Employer 0020=Employees 0040=Autonomous Default Value: 0010 |
| 9 | GPBR_TOT_AMT | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Total Amount |
| 10 | GPBR_TOT_AMT2 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Capital Stock - Establishment GRCS Report |
| 11 | GPBR_DEDUCTION_AMT | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Other Deduction Amount GRCS |
| 12 | GPBR_DISCOUNT_AMT | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Discount Amount GRCS |
| 13 | GPBR_FINE_AMOUNT | Number(13,2) | DECIMAL(12,2) NOT NULL | Fine Amount for GRFC Reporting |
| 14 | GPBR_OTHER_AMOUNT | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Other Compensations amount |