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 |