DISCOBJECTID1DISCOBJECTID2DISCOBJECTID3Prompt Table: PSRECDEFNPVW
Prompt Table: PSDBFIELDNAMEVW
PSMSFTABLES(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DISCOBJECTID1 |
Character(50) | VARCHAR2(50) NOT NULL | Disconnected Object ID 1 |
| 2 | DISCOBJECTID2 |
Character(50) | VARCHAR2(50) NOT NULL | Disconnected Object ID 2 |
| 3 | DISCOBJECTID3 |
Character(50) | VARCHAR2(50) NOT NULL | Disconnected Object ID 3 |
| 4 | PARENTRECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Parent Record Name
Prompt Table: PSRECDEFNPVW |
| 5 | PARENTFIELDNAME | Character(18) | VARCHAR2(18) NOT NULL |
Field Name
Prompt Table: PSDBFIELDNAMEVW |
| 6 | WHERE_CLAUSE | Long Character(500) | VARCHAR2(500) | Where Clause |
| 7 | RANGESIZE | Signed Number(4,0) | DECIMAL(3) NOT NULL | Range Size |
| 8 | ARANGE | Number(3,0) | SMALLINT NOT NULL | Available Ranges |
| 9 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |