OPRIDRUN_CNTL_IDY/N Table Edit
Default Value: N
PY_FFCRA_RUNCTL(SQL Table) |
Index Back |
|---|---|
FFCRA Load Run ControlThis record is used as the Run Control for the FFCRA Load process. This process is used to populate FFCRA Earnings which Year End load (TAX910LD) process can pick up. |
| # | 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 | BALANCE_ID | Character(2) | VARCHAR2(2) NOT NULL | Balance ID |
| 4 | BALANCE_YEAR | Number(4,0) | SMALLINT NOT NULL | Balances for Year |
| 5 | ERNCD | Character(3) | VARCHAR2(3) NOT NULL | Earnings Code |
| 6 | ERNCD2 | Character(3) | VARCHAR2(3) NOT NULL | Rapid Paysheets Earning Code |
| 7 | ERNCD3 | Character(3) | VARCHAR2(3) NOT NULL | Rapid Paysheets Earning Code |
| 8 | ASOFDATE | Date(10) | DATE | As of Date |
| 9 | LD_FFCRA_EXCEP | Character(1) | VARCHAR2(1) NOT NULL |
Load FFCRA exceptions
Y/N Table Edit Default Value: N |