PTRTIGUIDD=Delete
I=Insert
U=Update
PTSF_RTISTG_B(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PTRTIGUID |
Character(36) | VARCHAR2(36) NOT NULL | RTI |
| 2 | HOSTNAME | Character(254) | VARCHAR2(254) NOT NULL | Host |
| 3 | PROCESSID | Signed Number(11,0) | DECIMAL(10) NOT NULL | Process Identifier |
| 4 | PTRTIINSERTDTTM | DateTime(26) | TIMESTAMP | RTI |
| 5 | PTRTISTATUS | Number(3,0) | SMALLINT NOT NULL | RTI |
| 6 | PTSF_RTI_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Type of operation
D=Delete I=Insert U=Update |
| 7 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 8 | 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. |
| 9 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 10 | PTSF_KEY1_NAME | Character(18) | VARCHAR2(18) NOT NULL | Key 1 Field Name |
| 11 | PTSF_KEY1_VAL | Character(65) | VARCHAR2(65) NOT NULL | Key 1 Value |
| 12 | PTSF_KEY2_NAME | Character(18) | VARCHAR2(18) NOT NULL | Key 2 Field Name |
| 13 | PTSF_KEY2_VAL | Character(65) | VARCHAR2(65) NOT NULL | Key 2 Value |
| 14 | PTSF_KEY3_NAME | Character(18) | VARCHAR2(18) NOT NULL | Key 3 Field Name |
| 15 | PTSF_KEY3_VAL | Character(65) | VARCHAR2(65) NOT NULL | Key 3 Value |
| 16 | PTSF_KEY4_NAME | Character(18) | VARCHAR2(18) NOT NULL | Key 4 Field Name |
| 17 | PTSF_KEY4_VAL | Character(65) | VARCHAR2(65) NOT NULL | Key 4 Value |
| 18 | PTSF_KEY5_NAME | Character(18) | VARCHAR2(18) NOT NULL | Key 5 Field Name |
| 19 | PTSF_KEY5_VAL | Character(65) | VARCHAR2(65) NOT NULL | Key5 Value |
| 20 | PTSF_KEY6_NAME | Character(18) | VARCHAR2(18) NOT NULL | Key 6 Field Name |
| 21 | PTSF_KEY6_VAL | Character(65) | VARCHAR2(65) NOT NULL | Key 6 Value |
| 22 | PTSF_KEY7_NAME | Character(18) | VARCHAR2(18) NOT NULL | Key 7 Field Name |
| 23 | PTSF_KEY7_VAL | Character(65) | VARCHAR2(65) NOT NULL | Key 7 Value |
| 24 | PTSF_KEY8_NAME | Character(18) | VARCHAR2(18) NOT NULL | Key 8 Field Name |
| 25 | PTSF_KEY8_VAL | Character(65) | VARCHAR2(65) NOT NULL | Key 8 Value |
| 26 | PTSF_KEY9_NAME | Character(18) | VARCHAR2(18) NOT NULL | Key 9 Field Name |
| 27 | PTSF_KEY9_VAL | Character(65) | VARCHAR2(65) NOT NULL | Key 9 Value |
| 28 | PTSF_KEY10_NAME | Character(18) | VARCHAR2(18) NOT NULL | Key 10 Field Name |
| 29 | PTSF_KEY10_VAL | Character(65) | VARCHAR2(65) NOT NULL | Key 10 Value |
| 30 | PTSF_KEY11_NAME | Character(18) | VARCHAR2(18) NOT NULL | Key 11 Field Name |
| 31 | PTSF_KEY11_VAL | Character(65) | VARCHAR2(65) NOT NULL | Key 11 Value |
| 32 | PTSF_KEY12_NAME | Character(18) | VARCHAR2(18) NOT NULL | Key 12 Field Name |
| 33 | PTSF_KEY12_VAL | Character(65) | VARCHAR2(65) NOT NULL | Key 12 Value |
| 34 | PTSF_KEY13_NAME | Character(18) | VARCHAR2(18) NOT NULL | Key 13 Field Name |
| 35 | PTSF_KEY13_VAL | Character(65) | VARCHAR2(65) NOT NULL | Key 13 Value |
| 36 | PTSF_KEY14_NAME | Character(18) | VARCHAR2(18) NOT NULL | Key 14 Field Name |
| 37 | PTSF_KEY14_VAL | Character(65) | VARCHAR2(65) NOT NULL | Key 14 Value |
| 38 | PTSF_KEY15_NAME | Character(18) | VARCHAR2(18) NOT NULL | Key 15 Field Name |
| 39 | PTSF_KEY15_VAL | Character(65) | VARCHAR2(65) NOT NULL | Key 15 Value |
| 40 | PTSF_KEY16_NAME | Character(18) | VARCHAR2(18) NOT NULL | Key 16 Field Name |
| 41 | PTSF_KEY16_VAL | Character(65) | VARCHAR2(65) NOT NULL | Key 16 Value |