PSRECDDLPARM(SQL Table) |
Index Back |
---|---|
Record DDL Parameter |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: PSRECDEFN |
2 | PLATFORMID | Number(2,0) | SMALLINT NOT NULL |
Platform ID
0=SQLBase 1=DB2 2=Oracle 3=Informix 4=DB2/Unix 5=ALLBASE 6=Sybase 7=Microsoft 8=DB2/400 |
3 | SIZINGSET | Number(3,0) | SMALLINT NOT NULL | Sizing Set |
4 | PARMNAME | Character(8) | VARCHAR2(8) NOT NULL | DDL Parameter Name |
5 | PARMVALUE | Character(128) | VARCHAR2(128) NOT NULL | DDL Parameter Value |