SUP_USRAPRVL_VW

(SQL View)
 Index Back

Supplier User Regis View


SELECT HDR.OPRID ,HDR.DESCR ,HDR.CURRENCY_CD ,( SELECT CUR.DESCR FROM PS_CURRENCY_CD_TBL CUR WHERE HDR.CURRENCY_CD = CUR.CURRENCY_CD AND CUR.EFFDT = ( SELECT MAX(CUR1.EFFDT) FROM PS_CURRENCY_CD_TBL CUR1 WHERE CUR.CURRENCY_CD = CUR1.CURRENCY_CD AND CUR1.EFFDT <= %CurrentDateIn AND CUR1.EFF_STATUS = 'A')) AS DESCR1,HDR.TIMEZONE ,( SELECT TIMEZONE.TZDESCR FROM PSTIMEZONE TIMEZONE WHERE HDR.TIMEZONE = TIMEZONE.TIMEZONE) AS TIMEZONE_DESCR , HDR.EMAILID ,HDR.LANGUAGE_CD , ( SELECT XLAT.XLATLONGNAME FROM PSXLATITEM XLAT WHERE XLAT.FIELDNAME = 'LANGUAGE_CD' AND XLAT.FIELDVALUE = HDR.LANGUAGE_CD) AS DESCR3 ,HDR.SUP_TMPL_USRID ,CASE WHEN HDR.DESCR = ' ' THEN HDR.OPRID ELSE HDR.DESCR END AS DESCR60 FROM PS_SUP_OB_USR_REG HDR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
3 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_TBL

4 DESCR1 Character(30) VARCHAR2(30) NOT NULL Currency Description
5 TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone

Prompt Table: PSTIMEZONE

6 TZDESCR Character(50) VARCHAR2(50) NOT NULL Time Zone Description
7 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address
8 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
9 DESCR3 Character(30) VARCHAR2(30) NOT NULL Language Description
10 SUP_TMPL_USRID Character(30) VARCHAR2(30) NOT NULL Supplier Template Default User Id
11 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description