PK_LIC_OBJ_VW

(SQL View)
 Index Back

Packaging - Product Licensing


SELECT pk_license_code ,pk_release ,pk_product_line ,pk_objecttype ,pk_objectname ,objectownerid FROM PS_PK_LICENSE_DEFN WHERE 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
EPMW=EPM WorkBench
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 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier