PSCUBTEMPL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CUB_TEMPLID	Character(30)	VARCHAR2(30) NOT NULL	Template ID
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
3	DESCRLONG	Long Character	CLOB	Long Description
4	VERSION	Number(10,0)	DECIMAL(10) NOT NULL	Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
5	CUB_CONSOLPROP	Character(2)	VARCHAR2(2) NOT NULL	Consolidation Property 01=Add 02=Minus 03=Multiply 04=Divide 05=Percentage 06=None Default Value: 01
6	CUB_EXPREPORT	Character(1)	VARCHAR2(1) NOT NULL	Expense Report Y/N Table Edit Default Value: N
7	CUB_TIMEBAL	Character(1)	VARCHAR2(1) NOT NULL	Time Balance 0=None 1=First 2=Last 3=Average Default Value: 0
8	CUB_SKIPOPT	Character(1)	VARCHAR2(1) NOT NULL	Skip Option 0=None 1=Missing 2=Zeros 3=Missing and Zeros Default Value: 0
9	CUB_LABELONLY	Character(1)	VARCHAR2(1) NOT NULL	Label Only Y/N Table Edit Default Value: N
10	CUB_STORAGEOPT	Character(1)	VARCHAR2(1) NOT NULL	Data Storage 0=Default 1=Dynamic Calc 2=Dynamic Calc and Store 3=Never Share 4=Label Only Default Value: 0
11	CUB_NEVERSHARE	Character(1)	VARCHAR2(1) NOT NULL	Never Share Y/N Table Edit Default Value: N
12	CUB_LABELOPT	Character(1)	VARCHAR2(1) NOT NULL	Label Options 0=Use User Text 1=Use Query Long Label 2=Use Short Label Default Value: 0
13	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
14	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
15	OBJECTOWNERID	Character(4)	VARCHAR2(4) NOT NULL	Object owner identifier