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