HR_TBH_TMPLS_VW(SQL View) |
Index Back |
---|---|
Template Section ViewJoins the Template Section table with the Section Definition table. |
SELECT A.TBH_TMPL_ID , A.EFFDT , A.TBH_SECTION_ID , A.SEQ_NBR , A.TEXT_ID , A.ENABLED , A.HIDDEN_FLAG , A.PAGE_NUM , A.TBH_SEC_STYLE , B.DESCRSHORT , B.DESCR50 , B.DESCRLONG , B.TBH_SECTION_TYPE , B.TBH_SEC_TYPE_VAL , B.APPCLASSID , B.APPCLASS_PATH , B.METHODNAME FROM PS_HR_TBH_TMPL_SEC A , PS_HR_TBH_SECDEFN B WHERE B.TBH_SECTION_ID = A.TBH_SECTION_ID |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(18) | VARCHAR2(18) NOT NULL | Template ID | |
2 | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
|
3 | Character(18) | VARCHAR2(18) NOT NULL |
Template Section ID
Prompt Table: HR_TBH_SEC_VW0 |
|
4 | SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL |
Sequence Number
Default Value: 1 |
5 | TEXT_ID | Character(18) | VARCHAR2(18) NOT NULL |
Text ID
Prompt Table: HR_TBH_TXTID_VW |
6 | ENABLED | Character(1) | VARCHAR2(1) NOT NULL |
A flag indicates whether this row is enabled or not.
Y/N Table Edit Default Value: Y |
7 | HIDDEN_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Hidden Flag
Y/N Table Edit Default Value: N |
8 | PAGE_NUM | Number(5,0) | INTEGER NOT NULL | Page Nbr |
9 | TBH_SEC_STYLE | Character(1) | VARCHAR2(1) NOT NULL |
This field is to indicate the type of the section - Tabular or Grid
G=Grid T=Tabular Default Value: T |
10 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
11 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
12 | DESCRLONG | Long Character | CLOB | Long Description |
13 | TBH_SECTION_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Template Section Type
A=Address C=Country Specific F=Federal G=General J=Profile Item N=Name Default Value: G |
14 | TBH_SEC_TYPE_VAL | Character(12) | VARCHAR2(12) NOT NULL |
Section Type Value
Prompt Table: %EDITTABLE |
15 | APPCLASSID | Character(30) | VARCHAR2(30) NOT NULL | Application Class ID |
16 | APPCLASS_PATH | Character(254) | VARCHAR2(254) NOT NULL | Application Class Full Path |
17 | METHODNAME | Character(32) | VARCHAR2(32) NOT NULL | Method Name |