PTADSNAMERECNAMEPrompt Table: PSADSDFL_RECQRY
FIELDNAMEPrompt Table:
PSADSDFL_FLDQRY
Set Control Field: RECNAME
L=Literal Value
S=SQL Statement
PSADSDEFAULTS(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PTADSNAME |
Character(30) | VARCHAR2(30) NOT NULL | Data Set Name (see PSADSDEFN). |
| 2 | RECNAME |
Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: PSADSDFL_RECQRY |
| 3 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table:
PSADSDFL_FLDQRY
|
| 4 | PTDEFAULTTYPE | Character(1) | VARCHAR2(1) NOT NULL |
Default Type
L=Literal Value S=SQL Statement |
| 5 | PTDEFAULTVALUE | Long Character(14000) | CLOB | Default expression |