FLD_REQ_T_TREES (SQL Table)	Index Back
Field Request Template Trees Field Request Template Trees Note: Can't use EFFDT as component processor will treat this record as effective-dated, so use TREE_EFFDT instead.

FLD_REQ_T_TREES

(SQL Table)

Field Request Template Trees

Field Request Template Trees Note: Can't use EFFDT as component processor will treat this record as effective-dated, so use TREE_EFFDT instead.

Parent record: FLD_REQ_TMPLT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW

2 FIELDNAME1 Character(18) VARCHAR2(18) NOT NULL Field Name 1
Prompt Table: FLD_REQ_SFLD_VW

3 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name
Prompt Table: FLD_REQ_TREE_VW

4 TREE_EFFDT Date(10) DATE NOT NULL Effective date of the Tree

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
2	FIELDNAME1	Character(18)	VARCHAR2(18) NOT NULL	Field Name 1 Prompt Table: FLD_REQ_SFLD_VW
3	TREE_NAME	Character(18)	VARCHAR2(18) NOT NULL	Tree Name Prompt Table: FLD_REQ_TREE_VW
4	TREE_EFFDT	Date(10)	DATE NOT NULL	Effective date of the Tree