RC_TAX106CN(SQL Table) |
Index Back |
|---|---|
Run control for TAX106CN |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: PRCSRUNCNTL.OPRID |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL |
Run Control ID
Default Value: PRCSRUNCNTL.RUN_CNTL_ID |
| 3 | BALANCE_YEAR | Number(4,0) | SMALLINT NOT NULL |
Balances for Year
Default Value: 2020 |
| 4 | PY_T4_CO_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Processing Option
A=All Companies S=Selected Companies Default Value: A |
| 5 | BOX_AA_ERNCD | Character(3) | VARCHAR2(3) NOT NULL |
Employment Income - Code 57
Prompt Table: EARNINGS_TBL |
| 6 | BOX_BB_ERNCD | Character(3) | VARCHAR2(3) NOT NULL |
Employment Income - Code 58
Prompt Table: EARNINGS_TBL |
| 7 | BOX_CC_ERNCD | Character(3) | VARCHAR2(3) NOT NULL |
Employment Income - Code 59
Prompt Table: EARNINGS_TBL |
| 8 | BOX_DD_ERNCD | Character(3) | VARCHAR2(3) NOT NULL |
Employment Income - Code 60
Prompt Table: EARNINGS_TBL |