RC_TAX908CN(SQL Table) |
Index Back |
---|---|
Run control for TAX908CNRun control for Canada Emergency Wage Subsidy Report. |
# | 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 | PY_CEWS_START_DT | Date(10) | DATE |
Claim Period Begin Date
Prompt Table: PY_CEWS_DEF_TBL |
4 | PY_CEWS_END_DT | Date(10) | DATE | Claim Period End Date |
5 | PY_CEWS_CO_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Processing Option
A=All Companies S=Selected Companies Default Value: A |
6 | PY_CEWS_FORMULA | Character(1) | VARCHAR2(1) NOT NULL |
Calculation Formula
C=Use Current Remuneration P=Use Pre-Crisis Remuneration |