FO_TEMPL_TYP_VW

(SQL View)

SELECT a.template_pg_code , a.fo_template_type , a.descr FROM PS_FO_TEMPLATE_TYP a

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TEMPLATE_PG_CODE Character(4) VARCHAR2(4) NOT NULL Use Template Page
APP=Application
APPL=Application
ASGN=Assignments
CONT=Contacts
CRED=Credit Information
CUSQ=Customer Quality Feedback
CUST=Customers
EMPQ=Employee Customer Feedback
INSM=Interview Summary
INWK=Interview Worksheet
LICN=License Information
ORDR=Orders
OTHR=Other Data
REFR=References
WRKM=Worksite Master
Prompt Table: FO_TEMPLATE_TYP

2 FO_TEMPLATE_TYPE Character(4) VARCHAR2(4) NOT NULL Form Type
Prompt Table: FO_TEMPLATE_TYP

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TEMPLATE_PG_CODE	Character(4)	VARCHAR2(4) NOT NULL	Use Template Page APP=Application APPL=Application ASGN=Assignments CONT=Contacts CRED=Credit Information CUSQ=Customer Quality Feedback CUST=Customers EMPQ=Employee Customer Feedback INSM=Interview Summary INWK=Interview Worksheet LICN=License Information ORDR=Orders OTHR=Other Data REFR=References WRKM=Worksite Master Prompt Table: FO_TEMPLATE_TYP
2	FO_TEMPLATE_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Form Type Prompt Table: FO_TEMPLATE_TYP
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description