IT_SW_DSPLY_VW

(SQL View)
Index Back

Software Authorization

Level 1 scroll record in page IT_SFTWR_DEFN_01

%SelectAll(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 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