PI_SYSTEM_IDPS_RECORD_NMPS_FIELD1_NMPI_RECFLD_VW(SQL View) |
Index Back |
|---|---|
Field Definition for RecordView of Payroll Interface Field Definition for Record |
| SELECT PI_SYSTEM_ID, RECNAME, FIELDNAME FROM PS_PI_PSREC_FLD |
| # | 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 | PS_FIELD1_NM |
Character(18) | VARCHAR2(18) NOT NULL | PeopleSoft Field1 Name |