PK_LIC_DEFN_VW (SQL View)	Index Back
Packaging - Product Licensing

PK_LIC_DEFN_VW

(SQL View)

Packaging - Product Licensing

SELECT a.pk_license_code ,a.pk_release ,a.pk_product_line ,a.pk_objecttype ,a.pk_objectname ,a.pk_activeflag ,B.objectownerid ,a.lastupdoprid ,a.lastupddttm FROM ps_pk_license_defn a , PS_PK_OBJID_VW B WHERE A.PK_OBJECTNAME = B.PK_OBJECTNAME AND A.PK_OBJECTTYPE = B.PK_OBJECTTYPE AND a.pk_activeflag = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PK_LICENSE_CODE Character(4) VARCHAR2(4) NOT NULL License code
Prompt Table: PK_LICENSE_VW

2 PK_RELEASE Character(10) VARCHAR2(10) NOT NULL Release
Prompt Table: PK_LICENSE_CODE

3 PK_PRODUCT_LINE Character(4) VARCHAR2(4) NOT NULL Product Line
BDPL=Budget Planning
CIS=Customer Information Systems
CRM=Customer Relationship Mgmt
EC=Enterprise Components
EL=Enterprise Learning Solutions
EPM=Enterprise Performance Mgmt
EPRT=Portal Solutions
FIN=Financials
HRMS=HRMS
IA=Insurance Administration
LS=Learning Solutions
MP=MarketPlace
PBAM=People Tools Bus Anal Modeler
PTAX=Property Tax
PTLS=PeopleTools
RMS=Revenue Management Solution
SCM=Supply Chain Management
SCP=Supply Chain Planning
SIM=Incentive Management
STFO=Staffing Front Office
XTLS=Translations

4 PK_OBJECTTYPE Character(4) VARCHAR2(4) NOT NULL Added XLAT value for IScript 7/26/2001 ESHI
AE=App Engine
ISCR=IScript
PAGE=Page

5 PK_OBJECTNAME Character(18) VARCHAR2(18) NOT NULL Object Name

6 PK_ACTIVEFLAG Character(1) VARCHAR2(1) NOT NULL Active Flag
A=Active
I=Inactive
Default Value: A

7 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier

8 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.

9 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PK_LICENSE_CODE	Character(4)	VARCHAR2(4) NOT NULL	License code Prompt Table: PK_LICENSE_VW
2	PK_RELEASE	Character(10)	VARCHAR2(10) NOT NULL	Release Prompt Table: PK_LICENSE_CODE
3	PK_PRODUCT_LINE	Character(4)	VARCHAR2(4) NOT NULL	Product Line BDPL=Budget Planning CIS=Customer Information Systems CRM=Customer Relationship Mgmt EC=Enterprise Components EL=Enterprise Learning Solutions EPM=Enterprise Performance Mgmt EPRT=Portal Solutions FIN=Financials HRMS=HRMS IA=Insurance Administration LS=Learning Solutions MP=MarketPlace PBAM=People Tools Bus Anal Modeler PTAX=Property Tax PTLS=PeopleTools RMS=Revenue Management Solution SCM=Supply Chain Management SCP=Supply Chain Planning SIM=Incentive Management STFO=Staffing Front Office XTLS=Translations
4	PK_OBJECTTYPE	Character(4)	VARCHAR2(4) NOT NULL	Added XLAT value for IScript 7/26/2001 ESHI AE=App Engine ISCR=IScript PAGE=Page
5	PK_OBJECTNAME	Character(18)	VARCHAR2(18) NOT NULL	Object Name
6	PK_ACTIVEFLAG	Character(1)	VARCHAR2(1) NOT NULL	Active Flag A=Active I=Inactive Default Value: A
7	OBJECTOWNERID	Character(4)	VARCHAR2(4) NOT NULL	Object owner identifier
8	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.
9	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.