EMPLIDEMPL_RCDPI_RUN_NUMCOMPANYPAYGROUPEXPORT_SEQEFFDTN=No
P=Process Change
Y=Yes
PI_PARTIC_EXPT(SQL Table) |
Index Back |
|---|---|
PYI Participant Output-ExportPayroll Interface Export Participant (Employee) Output Detail |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 3 | PI_RUN_NUM |
Number(4,0) | SMALLINT NOT NULL | Payroll Interface Run Number |
| 4 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL | Company |
| 5 | PAYGROUP |
Character(3) | VARCHAR2(3) NOT NULL | Pay Group |
| 6 | EXPORT_SEQ |
Number(3,0) | SMALLINT NOT NULL | Export Sequence Number |
| 7 | EFFDT |
Date(10) | DATE | Effective Date |
| 8 | PI_SYSTEM_ID | Character(4) | VARCHAR2(4) NOT NULL | Payroll Interface System ID |
| 9 | PI_CONFIG_ID | Character(6) | VARCHAR2(6) NOT NULL | PI Configuration ID |
| 10 | PI_EMPLID | Character(20) | VARCHAR2(20) NOT NULL | Payroll Interface EMPLID |
| 11 | PI_EXPORT_SEQ | Character(50) | VARCHAR2(50) NOT NULL | Payroll Interface Export Seq |
| 12 | PI_FILE_ID | Character(6) | VARCHAR2(6) NOT NULL | Payroll Interface File ID |
| 13 | PI_RECORD_SEQ | Number(3,0) | SMALLINT NOT NULL | Payroll Interface Record Seq# |
| 14 | PI_RECORD_ID | Character(4) | VARCHAR2(4) NOT NULL | Payroll Interface Record ID |
| 15 | PI_CHANGE_IND | Character(1) | VARCHAR2(1) NOT NULL |
Payroll Interface Change Ind
N=No P=Process Change Y=Yes |
| 16 | EXPORT_ROW | Character(250) | VARCHAR2(250) NOT NULL | Export Row |