RECNAMEPrompt Table: HR_TBH_RECLKPVW
HR_TBH_RECDEFVW(SQL View) |
Index Back |
|---|---|
Template Record ViewSearch 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.RECDESCR FROM PS_HR_TBH_RECDEFN A , PSRECDEFN 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).
Prompt Table: HR_TBH_RECLKPVW |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |