PTSF_INDDATA_ER(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  RECNAME |
Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 2 | PTSF_KEY1_NAME | Character(18) | VARCHAR2(18) NOT NULL | Key 1 Field Name |
| 3 | PTSF_KEY1_VAL |
Character(65) | VARCHAR2(65) NOT NULL | Key 1 Value |
| 4 | PTSF_KEY2_NAME | Character(18) | VARCHAR2(18) NOT NULL | Key 2 Field Name |
| 5 | PTSF_KEY2_VAL |
Character(65) | VARCHAR2(65) NOT NULL | Key 2 Value |
| 6 | PTSF_KEY3_NAME | Character(18) | VARCHAR2(18) NOT NULL | Key 3 Field Name |
| 7 | PTSF_KEY3_VAL |
Character(65) | VARCHAR2(65) NOT NULL | Key 3 Value |
| 8 | PTSF_KEY4_NAME | Character(18) | VARCHAR2(18) NOT NULL | Key 4 Field Name |
| 9 | PTSF_KEY4_VAL |
Character(65) | VARCHAR2(65) NOT NULL | Key 4 Value |
| 10 | PTSF_KEY5_NAME | Character(18) | VARCHAR2(18) NOT NULL | Key 5 Field Name |
| 11 | PTSF_KEY5_VAL |
Character(65) | VARCHAR2(65) NOT NULL | Key5 Value |
| 12 | PTSF_KEY6_NAME | Character(18) | VARCHAR2(18) NOT NULL | Key 6 Field Name |
| 13 | PTSF_KEY6_VAL |
Character(65) | VARCHAR2(65) NOT NULL | Key 6 Value |
| 14 | PTSF_KEY7_NAME | Character(18) | VARCHAR2(18) NOT NULL | Key 7 Field Name |
| 15 | PTSF_KEY7_VAL |
Character(65) | VARCHAR2(65) NOT NULL | Key 7 Value |
| 16 | PTSF_KEY8_NAME | Character(18) | VARCHAR2(18) NOT NULL | Key 8 Field Name |
| 17 | PTSF_KEY8_VAL |
Character(65) | VARCHAR2(65) NOT NULL | Key 8 Value |
| 18 | PTSF_KEY9_NAME | Character(18) | VARCHAR2(18) NOT NULL | Key 9 Field Name |
| 19 | PTSF_KEY9_VAL |
Character(65) | VARCHAR2(65) NOT NULL | Key 9 Value |
| 20 | PTSF_KEY10_NAME | Character(18) | VARCHAR2(18) NOT NULL | Key 10 Field Name |
| 21 | PTSF_KEY10_VAL |
Character(65) | VARCHAR2(65) NOT NULL | Key 10 Value |
| 22 | PTSF_KEY11_NAME | Character(18) | VARCHAR2(18) NOT NULL | Key 11 Field Name |
| 23 | PTSF_KEY11_VAL |
Character(65) | VARCHAR2(65) NOT NULL | Key 11 Value |
| 24 | PTSF_KEY12_NAME | Character(18) | VARCHAR2(18) NOT NULL | Key 12 Field Name |
| 25 | PTSF_KEY12_VAL |
Character(65) | VARCHAR2(65) NOT NULL | Key 12 Value |
| 26 | PTSF_KEY13_NAME | Character(18) | VARCHAR2(18) NOT NULL | Key 13 Field Name |
| 27 | PTSF_KEY13_VAL |
Character(65) | VARCHAR2(65) NOT NULL | Key 13 Value |
| 28 | PTSF_KEY14_NAME | Character(18) | VARCHAR2(18) NOT NULL | Key 14 Field Name |
| 29 | PTSF_KEY14_VAL |
Character(65) | VARCHAR2(65) NOT NULL | Key 14 Value |
| 30 | PTSF_KEY15_NAME | Character(18) | VARCHAR2(18) NOT NULL | Key 15 Field Name |
| 31 | PTSF_KEY15_VAL |
Character(65) | VARCHAR2(65) NOT NULL | Key 15 Value |
| 32 | PTSF_KEY16_NAME | Character(18) | VARCHAR2(18) NOT NULL | Key 16 Field Name |
| 33 | PTSF_KEY16_VAL |
Character(65) | VARCHAR2(65) NOT NULL | Key 16 Value |
| 34 | PTSF_RTI_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Type of operation
D=Delete I=Insert U=Update |
| 35 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 36 | LASTUPDDTTM |
DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 37 | PTSF_FLD1_NAME | Character(18) | VARCHAR2(18) NOT NULL | Field 1 Name |
| 38 | PTSF_FLD1_OLD_VAL | Character(65) | VARCHAR2(65) NOT NULL | Field1 Old Value |
| 39 | PTSF_FLD2_NAME | Character(18) | VARCHAR2(18) NOT NULL | Field 2 Name |
| 40 | PTSF_FLD2_OLD_VAL | Character(65) | VARCHAR2(65) NOT NULL | Field 2 Old Value |
| 41 | PTSF_FLD3_NAME | Character(18) | VARCHAR2(18) NOT NULL | Field 3 Name |
| 42 | PTSF_FLD3_OLD_VAL | Character(65) | VARCHAR2(65) NOT NULL | Field 3 Old Value |
| 43 | PTSF_FLD4_NAME | Character(18) | VARCHAR2(18) NOT NULL | Field 4 Name |
| 44 | PTSF_FLD4_OLD_VAL | Character(65) | VARCHAR2(65) NOT NULL | Field 4 Old Value |
| 45 | PTSF_INDEX_NAME |
Character(65) | VARCHAR2(65) NOT NULL | Index Name |
| 46 | PTSF_FILENAME |
Character(254) | VARCHAR2(254) NOT NULL | File Name |
| 47 | PTSF_ERROR_CNT | Number(6,0) | INTEGER NOT NULL | Error Count |