PTSF_INDEX_NAMEPrompt Table: RECDEFN_VW
RECNAMEPrompt Table: RECDEFN_VW
N=Not Temp Table
Y=Temp Table
N=N
Y=Y
PTSF_INDEXTRREC(SQL Table) |
Index Back |
|---|---|
RTI Trigger Records |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PTSF_INDEX_NAME |
Character(65) | VARCHAR2(65) NOT NULL | Index Name |
| 2 | RECNAME1 | Character(15) | VARCHAR2(15) NOT NULL |
Record Name 1
Prompt Table: RECDEFN_VW |
| 3 | RECNAME |
Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: RECDEFN_VW |
| 4 | PTSF_IS_TEMPTABLE | Character(1) | VARCHAR2(1) NOT NULL |
Temp Table?
N=Not Temp Table Y=Temp Table |
| 5 | PTSF_TRFLDS | Character(1) | VARCHAR2(1) NOT NULL |
Add non-key field
N=N Y=Y |
| 6 | PTSF_CORRNAME | Character(65) | VARCHAR2(65) NOT NULL | Correlation Name |
| 7 | PTSF_SQLTEXT | Long Character | CLOB | SQL Text |
| 8 | SEQNUM | Number(3,0) | SMALLINT NOT NULL | Sequence Number |