IT_SFTWR_AUTH

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SFTWR_TITLE	Character(50)	VARCHAR2(50) NOT NULL	Software Title
2	AUTH_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Authorize D=Device Group E=Employee G=Employee Group Default Value: E
3	AUTH_ENTITY	Character(11)	VARCHAR2(11) NOT NULL	Value Prompt Table: %EDITTABLE
4	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
5	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
6	LICENSE_PER_USER	Number(3,0)	SMALLINT NOT NULL	Licenses Per User Default Value: 1
7	LICENSE_ALLOWED	Number(7,0)	INTEGER NOT NULL	Authorized Licenses
8	CNT_LICENSE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Count Licenses Y/N Table Edit Default Value: N