TBH_SECTION_IDDefault Value: 1
A=Address
C=Country Specific
F=Federal
G=General
N=Name
Default Value: G
Prompt Table: %EDITTABLE
HR_TBH_SEC_VW1(SQL View) |
Index Back |
|---|---|
Template Section ViewView against the Template Section Setup table returning all sections except the page zero configuration sections. |
| SELECT TBH_SECTION_ID , SEQ_NBR , TBH_SECTION_TYPE , TBH_SEC_TYPE_VAL FROM PS_HR_TBH_SECDEFN WHERE TBH_SECTION_ID NOT IN ('TBH_PAGE_ZERO', 'TBH_PAGE_ZERO_FED') |
| # | 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 N=Name Default Value: G |
| 4 | TBH_SEC_TYPE_VAL | Character(3) | VARCHAR2(3) NOT NULL |
Section Type Value
Prompt Table: %EDITTABLE |