BN_RTKEY_VW_LNG(SQL View) |
Index Back |
---|---|
Rate KeyField View Rel LangThis is a related language prompt view for selecting Benefit Rate Key fields. |
SELECT K.FIELDNAME , RL.LANGUAGE_CD , RL.LONGNAME FROM PS_BN_RATE_KEYS K , PSDBFLDLABL L , PSDBFLDLABLLANG RL WHERE K.LABEL_ID=' ' AND L.FIELDNAME=K.FIELDNAME AND L.DEFAULT_LABEL=1 AND RL.FIELDNAME=L.FIELDNAME AND RL.LABEL_ID=L.LABEL_ID UNION SELECT K.FIELDNAME , RL.LANGUAGE_CD , RL.LONGNAME FROM PS_BN_RATE_KEYS K , PSDBFLDLABLLANG RL WHERE K.LABEL_ID<>' ' AND RL.FIELDNAME=K.FIELDNAME AND RL.LABEL_ID=K.LABEL_ID |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: BN_RATE_KEYS |
2 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
3 | LONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Long Name |