PK_LIC_HDR_VW

(SQL View)
 Index Back

Packaging - Product Licensing


SELECT a.pk_license_code ,a.pk_release ,a.pk_product_line ,a.pk_objecttype ,b.descr FROM ps_pk_license_hdr a , PS_PK_LICENSE_CODE b WHERE a.pk_license_code = b.pk_license_code AND a.pk_release = b.pk_release AND a.pk_product_line = b.pk_product_line AND b.eff_status = 'A' AND b.effdt = ( SELECT MAX(b1.effdt) FROM PS_PK_LICENSE_CODE b1 WHERE b1.pk_license_code = b.pk_license_code AND b1.pk_release = b.pk_release AND b1.pk_product_line = b.pk_product_line AND b1.effdt <= %CurrentDateIn)

# 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_LIC_REL_VW

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 DESCR Character(30) VARCHAR2(30) NOT NULL Description