TBH_SECTION_IDDefault Value: 1
A=Address
C=Country Specific
F=Federal
G=General
J=Profile Item
N=Name
Default Value: G
Prompt Table: %EDITTABLE
HR_TBH_SEC_VW0(SQL View) |
Index Back |
|---|---|
Template Section ViewView against the Template Section Setup table returning all sections except the page zero configuration sections. |
| SELECT A.TBH_SECTION_ID , A.SEQ_NBR , A.TBH_SECTION_TYPE , A.TBH_SEC_TYPE_VAL , A.DESCRSHORT , A.DESCR50 , A.DESCRLONG , B.INSTANCE FROM PS_HR_TBH_SECDEFN A , PS_HR_TBH_SECDTL B WHERE A.TBH_SECTION_ID NOT IN ('TBH_PAGE_ZERO', 'TBH_PAGE_ZERO_FED') AND B.TBH_SECTION_ID = A.TBH_SECTION_ID AND B.SEQ_NBR = 1 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TBH_SECTION_ID |
Character(18) | VARCHAR2(18) NOT NULL | Template Section ID |
| 2 | SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL |
Sequence Number
Default Value: 1 |
| 3 | 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 |
| 4 | TBH_SEC_TYPE_VAL | Character(12) | VARCHAR2(12) NOT NULL |
Section Type Value
Prompt Table: %EDITTABLE |
| 5 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 6 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 7 | DESCRLONG | Long Character | CLOB | Long Description |
| 8 | INSTANCE | Number(3,0) | SMALLINT NOT NULL | Instance Number |