RECNAME_SEQPrompt Table: PSRECDEFN
FIELDNAMEPrompt Table: PSDBFIELD
RECFLD_SEQ_VW(SQL View) |
Index Back |
|---|---|
prompt of fields in a record |
| SELECT A.RECNAME ,A.FIELDNAME FROM PSRECFIELDDB A , PSDBFIELD B WHERE A.FIELDNAME=B.FIELDNAME AND B.FIELDTYPE IN (0, 2, 3) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RECNAME_SEQ |
Character(15) | VARCHAR2(15) NOT NULL |
Sequence Record Name
Prompt Table: PSRECDEFN |
| 2 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: PSDBFIELD |