GP_ABS_RCDFVWL(SQL View) |
Index Back |
---|---|
Template Record ViewConfigurable Sections: This is the related-language record for the Template Record View, which is the search view for the Template Record/Field Setup component. This view will exlcude the Instance Number and join the Template Record Setup Table to the PeopleTools Record Definition table so as to include the record name in field prompts. |
SELECT A.RECNAME , B.LANGUAGE_CD , B.RECDESCR FROM PS_HR_TBH_RECDEFN A , PSRECDEFNLANG B WHERE A.INSTANCE = 1 AND B.RECNAME = A.RECNAME |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
2 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |