PROCESS_INSTANCEA=All
E=Exclude Non Employee Compensat
I=Include Non Employee Compensat
Default Value: A
Default Value: N
WTHD_SNT_AET(SQL Table) |
Index Back |
|---|---|
WTHD_SNT process AETWTHD_SNT application engine cache record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | REQUEST_ID | Character(10) | VARCHAR2(10) NOT NULL | Request ID |
| 3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | WTHD_RPT_ID | Character(10) | VARCHAR2(10) NOT NULL | Withholding Report ID |
| 5 | WTHD_RPT_ID_DTL | Character(10) | VARCHAR2(10) NOT NULL | Withholding Report ID |
| 6 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 7 | WTHD_CNTL_ID | Character(10) | VARCHAR2(10) NOT NULL | Control ID |
| 8 | PROCESS_DTTM | DateTime(26) | TIMESTAMP | Process Date Time |
| 9 | INCL_NON_COMP_AMT | Character(1) | VARCHAR2(1) NOT NULL |
Include Box &
A=All E=Exclude Non Employee Compensat I=Include Non Employee Compensat Default Value: A |
| 10 | PAYER_TIN | Character(20) | VARCHAR2(20) NOT NULL | Payer Taxpayer Identification |
| 11 | IRS_FILE_SENT | Character(1) | VARCHAR2(1) NOT NULL |
IRS FILE SENT
Default Value: N |
| 12 | FISCAL_YEAR | Number(4,0) | SMALLINT NOT NULL | Fiscal Year |