PI_SYSTEM_IDPS_RECORD_NMB=Export/Import
E=Export
I=Import
PI_PS_REC_VW(SQL View) |
Index Back |
|---|---|
PI Peoplesoft record viewPayroll Interface Peoplesoft record view |
| SELECT PI_SYSTEM_ID, RECNAME, PI_PROCESS_TYPE FROM PS_PI_PS_RECORD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PI_SYSTEM_ID |
Character(4) | VARCHAR2(4) NOT NULL | Payroll Interface System ID |
| 2 | PS_RECORD_NM |
Character(15) | VARCHAR2(15) NOT NULL | PeopleSoft Record Name |
| 3 | PI_PROCESS_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Process Type
B=Export/Import E=Export I=Import |