PTP_SEQ_NBRPTP_TABLE1_VW(SQL View) |
Index Back |
|---|---|
Performance Test Page Table 1PTP Performance Test Page Table 1 |
| SELECT A.PTP_SEQ_NBR , A.PTP_SEQ_CHAR , A.DESCR ,A.PTP_INT01 FROM PS_PTP_TABLE1 A , PS_PTP_TABLE2 B WHERE A.PTP_SEQ_NBR = B.PTP_SEQ_NBR |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PTP_SEQ_NBR |
Number(6,0) | INTEGER NOT NULL | Performance Test - Sequence Number |
| 2 | PTP_SEQ_CHAR | Character(6) | VARCHAR2(6) NOT NULL | Performance Test - Sequence text |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | PTP_INT01 | Number(3,0) | SMALLINT NOT NULL | PTP Integer 01 |