EODP_CPMPRF_VW(SQL View) |
Index Back |
---|---|
View References Prompt recordView Refernces Main Record used in Data Privacy Component |
SELECT A.PNLGRPNAME , E.DESCR , A.PNLNAME , D.MESSAGE_TEXT , A.RECNAME , C.RECDESCR , A.FIELDNAME , A.LBLTEXT , CTG.EODP_CTGRY_DESC , CLS.EODP_CFCN_NAME , A.EODP_PERS_IDFR , A.EODP_SNSTV , F.EODP_PRODUCT_CD , F.EODP_OBJ_DESCR , B.MENUNAME , B.MARKET , B.PORTAL_NAME , B.PORTAL_OBJNAME , B.PORTAL_NAVPATH FROM PSRECDEFN C , PSMSGCATDEFN D , PSPNLGRPDEFN E , PS_EODP_PROD_VW F , PS_EODP_CTGRY_CODE CTG , PS_EODP_CLSFCN CLS , PS_EODP_COMP_REF A LEFT OUTER JOIN PS_EODP_COMPDETREF B ON A.PNLGRPNAME = B.PNLGRPNAME WHERE A.PNLGRPNAME <>'BLANK_DP' AND A.PNLNAME ='PROMPT_PAGE_DP' AND A.RECNAME = C.RECNAME AND A.PNLGRPNAME = E.PNLGRPNAME AND D.MESSAGE_SET_NBR=18111 AND D.MESSAGE_NBR=25815 AND E.OBJECTOWNERID = F.EODP_PRODUCT_CD AND A.EODP_CTGRY_CD = CTG.EODP_CTGRY_CD AND A.EODP_CLFNCD = CLS.EODP_CLFNCD AND B.MARKET = E.MARKET |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PNLGRPNAME | Character(18) | VARCHAR2(18) NOT NULL | Component Name |
2 | EODP_COMP_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Component Description |
3 | PNLNAME | Character(30) | VARCHAR2(30) NOT NULL | Page Name (see PSPNLDEFN). |
4 | EODP_PAGE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Page Description |
5 | EODP_RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record Name |
6 | RECDESCR | Character(30) | VARCHAR2(30) NOT NULL | Record Description |
7 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
8 | EODP_FIELD_DESCR | Character(60) | VARCHAR2(60) NOT NULL | Field Description |
9 | EODP_CTGRY_DESC | Character(100) | VARCHAR2(100) NOT NULL | Category |
10 | EODP_CFCN_NAME | Character(100) | VARCHAR2(100) NOT NULL | Classification |
11 | EODP_PERS_IDFR | Character(1) | VARCHAR2(1) NOT NULL |
Personal Identifier
A=All N=No Y=Yes Y/N Table Edit Default Value: N |
12 | EODP_SNSTV | Character(1) | VARCHAR2(1) NOT NULL |
Sensitive
A=All N=No Y=Yes Y/N Table Edit Default Value: N |
13 | EODP_PRODUCT_CD | Character(4) | VARCHAR2(4) NOT NULL | PeopleSoft Product Code. Created for Sensitive Data Framework |
14 | EODP_PROD_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Product Description |
15 | MENUNAME | Character(30) | VARCHAR2(30) NOT NULL | Menu Name (see PSMENUDEFN). |
16 | MARKET | Character(3) | VARCHAR2(3) NOT NULL | Market |
17 | PORTAL_NAME | Character(30) | VARCHAR2(30) NOT NULL | Portal Name (see PSPRDMDEFN). |
18 | PORTAL_OBJNAME | Character(30) | VARCHAR2(30) NOT NULL | Content Reference Name |
19 | PORTAL_NAVPATH | Long Character | CLOB | Navigation Path |