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_PG0SECVW(SQL View) |
Index Back |
|---|---|
Template Section ViewView against the Template Section Setup table returning only 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 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 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 |