PK_LICENSE_VW

(SQL View)
 Index Back

Packaging - Product Licensing


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

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PK_LICENSE_CODE Character(4) VARCHAR2(4) NOT NULL License code
2 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
3 DESCR Character(30) VARCHAR2(30) NOT NULL Description