HR_TBH_TMPLF_VW

(SQL View)
 Index Back

Template Field View

Joins the Template Field table with the Section Field Definition table.

SELECT A.TBH_TMPL_ID , A.EFFDT , A.TBH_SECTION_ID , A.RECNAME , A.INSTANCE , A.FIELDNAME , A.SEQ_NBR , A.TEXT_ID , A.TBH_COLUMN , A.REQUIRED_FLG , A.ENABLED , A.HIDDEN_FLAG , A.TBH_CHAR , A.TBH_NUM , A.TBH_DATE , A.TBH_DATETIME , A.TBH_TIME , A.TBH_LONG , B.TBH_DISPLAY_TYPE , B.PROMPT_TABLE , B.PROMPT_FIELD , B.TBH_DD_LIST_FLG , B.APPCLASSID , B.APPCLASS_PATH , B.METHODNAME , B.APPCLASSID2 , B.APPCLASS_PATH2 , B.METHODNAME2 FROM PS_HR_TBH_TMPL_FLD A , PS_HR_TBH_SECDTL B WHERE B.TBH_SECTION_ID = A.TBH_SECTION_ID AND B.RECNAME = A.RECNAME AND B.INSTANCE = A.INSTANCE AND B.FIELDNAME = A.FIELDNAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 TBH_TMPL_ID Character(18) VARCHAR2(18) NOT NULL Template ID
2 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

3 TBH_SECTION_ID Character(18) VARCHAR2(18) NOT NULL Template Section ID

Prompt Table: HR_TBH_SEC_VW0

4 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

Prompt Table: HR_TBH_SECDTL

5 INSTANCE Number(3,0) SMALLINT NOT NULL Instance Number

Default Value: 1

6 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

Prompt Table: HR_TBH_SECDTL

7 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number

Default Value: 1

8 TEXT_ID Character(18) VARCHAR2(18) NOT NULL Text ID

Prompt Table: HR_TBH_TXTID_VW

9 TBH_COLUMN Character(1) VARCHAR2(1) NOT NULL Template Column
E=Either
L=Left
R=Right

Default Value: E

10 REQUIRED_FLG Character(1) VARCHAR2(1) NOT NULL Required Flag

Y/N Table Edit

Default Value: N

11 ENABLED Character(1) VARCHAR2(1) NOT NULL A flag indicates whether this row is enabled or not.

Y/N Table Edit

Default Value: Y

12 HIDDEN_FLAG Character(1) VARCHAR2(1) NOT NULL Hidden Flag

Y/N Table Edit

Default Value: N

13 TBH_CHAR Character(70) VARCHAR2(70) NOT NULL Template Stage Charecter
14 TBH_NUM Number(19,6) DECIMAL(18,6) NOT NULL Template Stage Number
15 TBH_DATE Date(10) DATE Template Stage Date
16 TBH_DATETIME DateTime(26) TIMESTAMP Template Stage Datetime
17 TBH_TIME Time(15) TIMESTAMP Template Time
18 TBH_LONG Long Character(1325) VARCHAR2(1325) Template Stage Long
19 TBH_DISPLAY_TYPE Character(2) VARCHAR2(2) NOT NULL Template Display type
C=CheckBox
D=Date
LD=DropDown
LE=Edit Box
LG=Long Edit Box
LP=Prompt
SD=Short DropDown
SE=Short Edit Box
SP=Short Prompt

Default Value: LE

20 PROMPT_TABLE Character(15) VARCHAR2(15) NOT NULL Record Name

Prompt Table: HR_TBH_RECLKPVW

21 PROMPT_FIELD Character(18) VARCHAR2(18) NOT NULL This defines what field should be used when forming a prompt for a Configurable Matrix item.

Prompt Table: HR_TBH_PRMFLDVW

22 TBH_DD_LIST_FLG Character(1) VARCHAR2(1) NOT NULL Indicates whether code, description or both are shown in a dropdown list.
B=Code and Description
C=Code Only
D=Description Only

Default Value: D

23 APPCLASSID Character(30) VARCHAR2(30) NOT NULL Application Class ID
24 APPCLASS_PATH Character(254) VARCHAR2(254) NOT NULL Application Class Full Path
25 METHODNAME Character(32) VARCHAR2(32) NOT NULL Method Name
26 APPCLASSID2 Character(30) VARCHAR2(30) NOT NULL Application Class ID
27 APPCLASS_PATH2 Character(254) VARCHAR2(254) NOT NULL Application Class Path
28 METHODNAME2 Character(32) VARCHAR2(32) NOT NULL Method Name