GPIN_DS_SIG_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GPIN_DS_DIGID	Character(30)	VARCHAR2(30) NOT NULL	Digital Signature ID
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	USERID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
5	GPIN_DS_SIGNTYPE	Character(4)	VARCHAR2(4) NOT NULL	Signature Type JKS=Java Keystore P12=PKCS#12 Signature PFX=PFX Signature
6	PASSWORD	Character(254)	VARCHAR2(254) NOT NULL	Password
7	ATTACHSYSFILENAME	Character(128)	VARCHAR2(128) NOT NULL	Unique Sys Filename
8	ATTACHUSERFILE	Character(64)	VARCHAR2(64) NOT NULL	Attached File
9	VALID_FROM_DT	Date(10)	DATE	Valid from
10	VALID_THRU_DT	Date(10)	DATE	Valid Thru Date
11	GPIN_DS_COMNAME	Character(254)	VARCHAR2(254) NOT NULL	Digital Signature Common Name
12	GPIN_DS_ORGUNIT	Character(254)	VARCHAR2(254) NOT NULL	Digital Signature Organizational Unit
13	GPIN_DS_ORG	Character(254)	VARCHAR2(254) NOT NULL	Digital Signature Organization
14	GPIN_DS_LOCALITY	Character(254)	VARCHAR2(254) NOT NULL	Digital Signature Locality
15	GPIN_DS_STATE	Character(254)	VARCHAR2(254) NOT NULL	Digital Signature - State
16	GPIN_DS_EMAIL	Character(254)	VARCHAR2(254) NOT NULL	Digital Signature - Email
17	CREATEDTTM	DateTime(26)	TIMESTAMP	DateTime of Query Creation
18	CREATEOPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID
19	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.
20	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.