PI_SYSTEM_IDPrompt Table: PI_SYSTEM_TBL
PI_INSTANCE_IDEFFDTDefault Value: %date
O=Ordinal
V=Value
Prompt Table: PI_PS_REC_VW
Prompt Table: PI_RECFLD_VW
E=Exclude Values
I=Include Values
Default Value: I
PI_INSTANCE_TBL(SQL Table) |
Index Back |
|---|---|
PI Instance TablePayroll Interace Instance Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PI_SYSTEM_ID |
Character(4) | VARCHAR2(4) NOT NULL |
Payroll Interface System ID
Prompt Table: PI_SYSTEM_TBL |
| 2 | PI_INSTANCE_ID |
Character(6) | VARCHAR2(6) NOT NULL | Instance ID |
| 3 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 6 | PI_INSTANCE_IND | Character(1) | VARCHAR2(1) NOT NULL |
PI Instance Indicator
O=Ordinal V=Value |
| 7 | ROW_NUM | Number(3,0) | SMALLINT NOT NULL | Row Number |
| 8 | PS_RECORD_NM | Character(15) | VARCHAR2(15) NOT NULL |
PeopleSoft Record Name
Prompt Table: PI_PS_REC_VW |
| 9 | PS_FIELD1_NM | Character(18) | VARCHAR2(18) NOT NULL |
PeopleSoft Field1 Name
Prompt Table: PI_RECFLD_VW |
| 10 | INCLD_EXCLD_IND | Character(1) | VARCHAR2(1) NOT NULL |
Include Exclude Indicator
E=Exclude Values I=Include Values Default Value: I |