PY_YE_1099_RCTL(SQL Table) |
Index Back |
|---|---|
YE 1099-R Form Run ControlRun information to be passed to XML Publisher. |
| # | 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 | PRCSINSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 4 | PRCSNAME |
Character(12) | VARCHAR2(12) NOT NULL | Process Name |
| 5 | JOBINSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Job Instance |
| 6 | REPORT_DEFN_ID | Character(12) | VARCHAR2(12) NOT NULL | Report Name (see PSXPRPTDEFN). |
| 7 | TMPLDEFN_ID | Character(30) | VARCHAR2(30) NOT NULL | Template ID (see PSXPTMPLDEFN). |
| 8 | PY_YE_SOURCEFILE | Character(254) | VARCHAR2(254) NOT NULL | Filename of XML file generated by one of the year end forms SQR programs. |
| 9 | PY_YE_SOURCELOC | Character(254) | VARCHAR2(254) NOT NULL | Location where source XML file generated by one of the year end SQR programs is stored. |
| 10 | PY_YE_SRC_FILENAME | Character(254) | VARCHAR2(254) NOT NULL | Filename of XML file generated by one of the year end forms SQR programs, including file path. |
| 11 | PY_YE_OSPLATFORM | Character(4) | VARCHAR2(4) NOT NULL | Operating System Platform. Valid Values are: UNIX, MVS, NT |
| 12 | FORM_ID | Character(6) | VARCHAR2(6) NOT NULL | Form Identification |
| 13 | PY_W2_FINAL_PRINT | Character(1) | VARCHAR2(1) NOT NULL | Identifies whether final run or not. |
| 14 | PY_W2_COPY_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
W-2/W-2c Type
1=Government Copy 2=Employee Copy 4=Company Copy 5=Payee Copy 6=Payer Copy |
| 15 | PY_YE_RPT_BURST | Character(1) | VARCHAR2(1) NOT NULL |
Indicates if report bursting is required.
Y/N Table Edit |
| 16 | PY_YE_RPT_SS | Character(1) | VARCHAR2(1) NOT NULL | Indicates if report destination is a self-service application. |
| 17 | PY_RPT_DEFN_ID_SS | Character(12) | VARCHAR2(12) NOT NULL | Report Definition to be used for Self-Sevice. |
| 18 | PY_RPT_TMPL_ID_SS | Character(30) | VARCHAR2(30) NOT NULL | Report Template to be used for Self-Sevice. |
| 19 | 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 |
| 20 | PY_YE_SOURCEFILE2 | Character(254) | VARCHAR2(254) NOT NULL | Filename of XML file generated by one of the year end forms SQR programs. |
| 21 | PY_YE_SRC_FILENAM2 | Character(254) | VARCHAR2(254) NOT NULL | Filename of XML file generated by one of the year end forms SQR programs, including file path. |
| 22 | PY_YE_FILE_COUNT | Number(3,0) | SMALLINT NOT NULL | File Count |
| 23 | PY_YE_XMLURLID | Character(30) | VARCHAR2(30) NOT NULL | URL ID used to store and retrieve year-end xml data files. |
| 24 | PY_TAX_YEAR | Number(4,0) | SMALLINT NOT NULL | Represents the year for personal income tax purposes. |