TAXFORM_ACC_DTL(SQL Table) |
Index Back |
---|---|
Taxform Accessibility DetailsTaxform Accessibility Details |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | TAXFORM_ID | Character(1) | VARCHAR2(1) NOT NULL |
Tax Form Identification
A=T4A Slip B=Business Payrolls Survey - CAN C=WCB Assessable Earnings E=Record of Employment F=940 - Annual Employer's FUTA I=W-2VI J=W-2cVI M=W-2GU N=W-2cGU P=W-2PR Q=W-2cPR R=RL-1 Slip S=W-2AS T=T4 Slip U=W-2cAS V=RL-2 Slip W=W-2 X=W-2c Y=1099-R Z=1042-S |
2 | EFFDT | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
3 | SEQNO | Number(5,0) | INTEGER NOT NULL | Sequence Number |
4 | BOX | Character(4) | VARCHAR2(4) NOT NULL | Box |
5 | BOX_INDICATOR | Character(1) | VARCHAR2(1) NOT NULL |
Box Indicator for Taxform Accessibility Set-up
A=Amendment C=Employee Correction D=Form Details E=Employee Details F=Federal L=Local R=Employer Details S=State |
6 | STANDARD_VIEW | Character(1) | VARCHAR2(1) NOT NULL |
Standard View Box for Taxform Accessibility Set-up
Y/N Table Edit |
7 | TAXFORM_XML_ID | Character(50) | VARCHAR2(50) NOT NULL | Taxform XML Id |
8 | TAXFORM_PRE_XML_ID | Character(50) | VARCHAR2(50) NOT NULL | Taxform XML Id |
9 | PROCESS_INDICATOR | Character(1) | VARCHAR2(1) NOT NULL |
Processing Indicator for Taxform Accessibility Set-up
C=Correction N=Normal O=Overflow T=Other |
10 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |