HR_TBH_SEC_VW2L

(SQL View)
 Index Back

Template Section View

View joining the tempate section definition table to the transaction type section table.

SELECT A.TBH_SECTION_ID , C.LANGUAGE_CD , A.SEQ_NBR , A.TBH_SECTION_TYPE , A.TBH_SEC_TYPE_VAL , C.DESCR50 , B.TBH_TMPL_TXN_TYP FROM PS_HR_TBH_SECDEFN A , PS_HR_TBH_TXN_SEC B , PS_HR_TBH_SECDF_LN C WHERE B.TBH_SECTION_ID = A.TBH_SECTION_ID AND C.TBH_SECTION_ID = A.TBH_SECTION_ID UNION SELECT A.TBH_SECTION_ID , C.LANGUAGE_CD , A.SEQ_NBR , A.TBH_SECTION_TYPE , A.TBH_SEC_TYPE_VAL , A.DESCR50 , B.TBH_TMPL_TXN_TYP FROM PS_HR_TBH_SECDEFN A , PS_HR_TBH_TXN_SEC B , PS_HR_TBH_SECDF_LN C WHERE B.TBH_SECTION_ID = A.TBH_SECTION_ID AND NOT EXISTS ( SELECT 'X' FROM PS_HR_TBH_SECDF_LN D WHERE D.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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
3 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number

Default Value: 1

4 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

5 TBH_SEC_TYPE_VAL Character(12) VARCHAR2(12) NOT NULL Section Type Value

Prompt Table: %EDITTABLE

6 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
7 TBH_TMPL_TXN_TYP Character(10) VARCHAR2(10) NOT NULL Template Transaction Type