TBH_TMPL_IDEFFDTDefault Value: %date
RECNAMEPrompt Table: HR_TBH_SECDTL
INSTANCEDefault Value: 1
A=Active
I=Inactive
Default Value: A
Y/N Table Edit
Default Value: N
HR_TBH_TMPLR_VW(SQL View) |
Index Back |
|---|---|
Template Section ViewJoins the Template Section table with the Section Definition table. |
| SELECT DISTINCT A.TBH_TMPL_ID , A.EFFDT , A.RECNAME , A.INSTANCE , B.EFF_STATUS , B.ALIAS_TBL_NAME , B.TBH_USE_ONLY FROM PS_HR_TBH_TMPL_FLD A , PS_HR_TBH_RECDEFN B WHERE B.RECNAME = A.RECNAME AND B.INSTANCE = A.INSTANCE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TBH_TMPL_ID |
Character(18) | VARCHAR2(18) NOT NULL | Template ID |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | RECNAME |
Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: HR_TBH_SECDTL |
| 4 | INSTANCE |
Number(3,0) | SMALLINT NOT NULL |
Instance Number
Default Value: 1 |
| 5 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 6 | ALIAS_TBL_NAME | Character(18) | VARCHAR2(18) NOT NULL | Alias Table Name |
| 7 | TBH_USE_ONLY | Character(1) | VARCHAR2(1) NOT NULL |
Template-Based Hire Use Only
Y/N Table Edit Default Value: N |