CS_BINDFLD_VW(SQL View) |
Index Back |
---|
SELECT A.RECNAME , A.FIELDNAME , L.LONGNAME FROM PSRECFIELDDB A , PSDBFLDLABL L WHERE A.FIELDNAME = L.FIELDNAME AND L.DEFAULT_LABEL = 1 |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(15) | VARCHAR2(15) NOT NULL |
Binds Recordname
Prompt Table: CS_RECVIEW_VW |
|
2 | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). | |
3 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |