PSSEQUENCE

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PTSEQ_NAME	Character(30)	VARCHAR2(30) NOT NULL	DB sequence name
2	PTSEQ_SEED_COLUMN	Character(61)	VARCHAR2(61) NOT NULL	DB seq seed column
3	PTSEQ_START	Number(28,0)	DECIMAL(28) NOT NULL	DB seq start value Default Value: 1
4	PTSEQ_INCR	Number(28,0)	DECIMAL(28) NOT NULL	DB seq increment Default Value: 1
5	PTSEQ_MINVAL	Number(28,0)	DECIMAL(28) NOT NULL	DB seq minimum Default Value: 1
6	PTSEQ_MAXVAL	Number(28,0)	DECIMAL(28) NOT NULL	DB seq maximum Default Value: 999999999999999999
7	PTSEQ_CYCLE	Character(1)	VARCHAR2(1) NOT NULL	DB seq cycle flag Y/N Table Edit Default Value: N
8	PTSEQ_CACHE	Signed Number(29,0)	DECIMAL(28) NOT NULL	DB seq cache value Default Value: -1
9	VERSION	Number(10,0)	DECIMAL(10) NOT NULL	Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
10	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.
11	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.
12	OBJECTOWNERID	Character(4)	VARCHAR2(4) NOT NULL	Object owner identifier