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_VW1(SQL View) |
Index Back |
|---|---|
Template Section ViewView joining the tempate section definition table to the transaction type section table. |
| SELECT A.TBH_SECTION_ID , A.SEQ_NBR , A.TBH_SECTION_TYPE , A.TBH_SEC_TYPE_VAL , B.TBH_TMPL_TXN_TYP FROM PS_HR_TBH_SECDEFN A , PS_HR_TBH_TXN_SEC B WHERE B.TBH_SECTION_ID = A.TBH_SECTION_ID |
| # | 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 | TBH_TMPL_TXN_TYP | Character(10) | VARCHAR2(10) NOT NULL | Template Transaction Type |