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