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 | CS_BIND_RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Binds Recordname
Prompt Table: CS_RECVIEW_VW |
2 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
3 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |