PSDOCLODEFN

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	IBDOCLAYOUTNAME	Character(20)	VARCHAR2(20) NOT NULL	Layout Name
2	VERSION	Number(10,0)	DECIMAL(10) NOT NULL	Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
3	IB_DOCLAYOUTGRP	Character(30)	VARCHAR2(30) NOT NULL	Document Layout Group
4	IB_SERVICENAME	Character(30)	VARCHAR2(30) NOT NULL	Service (see PSSERVICE).
5	IB_PACKAGEID	Character(100)	VARCHAR2(100) NOT NULL	Referenced Package
6	IB_SCHEMANAME	Character(100)	VARCHAR2(100) NOT NULL	Document Name
7	IB_VARIANTNAME	Character(30)	VARCHAR2(30) NOT NULL	Version Name
8	IB_PACKAGE2	Character(100)	VARCHAR2(100) NOT NULL	Package Name
9	IB_SCHEMANAME2	Character(100)	VARCHAR2(100) NOT NULL	Document Name
10	IB_VARIANTNAME2	Character(30)	VARCHAR2(30) NOT NULL	Version Name
11	BCNAME	Character(30)	VARCHAR2(30) NOT NULL	Business Component Name (see PSBCDEFN). Prompt Table: PSBCDEFN
12	IBEXLAYOUTNAME	Character(20)	VARCHAR2(20) NOT NULL	Layout Name Prompt Table: PTIBMAPEXLO_DVW
13	IBCUSTPARENTLAYOUT	Character(20)	VARCHAR2(20) NOT NULL	Layout Name
14	IB_APPTYPE	Character(30)	VARCHAR2(30) NOT NULL	Application Type
15	IB_FORMAT	Number(3,0)	SMALLINT NOT NULL	Format
16	IB_DEFAULTSTYLE	Number(3,0)	SMALLINT NOT NULL	Default Style
17	IB_TITLE	Character(30)	VARCHAR2(30) NOT NULL	Title
18	IB_EXPIREDTTM	DateTime(26)	TIMESTAMP	Expired Cache Dttm
19	IB_CACHETIME	Number(5,0)	INTEGER NOT NULL	Re-Cache Time (Hours)
20	IB_CACHE_USERID	Number(3,0)	SMALLINT NOT NULL	Cache By UserId
21	IB_DOCLORESTRICT	Number(3,0)	SMALLINT NOT NULL	Layout Restricted
22	IB_SYSTEM_STATUS	Number(3,0)	SMALLINT NOT NULL	Layout System Status
23	IB_CUSTOM_THEME	Number(3,0)	SMALLINT NOT NULL	Custom Theme
24	IB_CUSTOMSWATCH	Character(10)	VARCHAR2(10) NOT NULL	Custom Swatch(s)
25	IB_JQUERYMOD	Number(3,0)	SMALLINT NOT NULL	jQuery Version
26	IB_JQUERYMOBILEMOD	Number(3,0)	SMALLINT NOT NULL	jQuery Mobile Version
27	IB_JQMOBILEMODCSS	Number(3,0)	SMALLINT NOT NULL	JQuery Mobile Version
28	IB_VALID_LEVEL	Number(1,0)	SMALLINT NOT NULL	Validation Level
29	IB_RAPHAEL	Number(1,0)	SMALLINT NOT NULL	Raphael
30	IB_DOC_DUMP	Number(1,0)	SMALLINT NOT NULL	Document Dump
31	IB_NO_CUSTOM	Number(1,0)	SMALLINT NOT NULL	No Custom
32	IB_CUST_INVALID	Number(1,0)	SMALLINT NOT NULL	Custom Invalid
33	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
34	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.
35	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.
36	OBJECTOWNERID	Character(4)	VARCHAR2(4) NOT NULL	Object owner identifier
37	DESCRLONG	Long Character	CLOB	Long Description