SPB_PERS_SES_VW

(SQL View)
 Index Back

Service Provider PTSF view

Service Provider PTSF view

SELECT A.PERSON_ID , A.SPRO_PERSON_TYPE , A.USER_ACC_STATUS , X1.XLATLONGNAME AS DESCR , A.FIRST_NAME , A.MIDDLE_NAME , A.LAST_NAME , A.SP_ELIGIBLE_STATUS , X2.XLATLONGNAME AS DESCR1 , B.EFFDT , B.VENDOR_ID , V.NAME1 , A.ROW_MODIFY_DATE , L.ses_last_dttm FROM PS_SPB_PERSON_TBL A , PS_SPB_PROV_CNT_VW B , PS_VENDOR V , PSXLATITEM X1 , PSXLATITEM X2 , PS_SP_SES_LAST_RUN L WHERE A.PERSON_ID = B.PERSON_ID AND V.VENDOR_ID = B.VENDOR_ID AND V.SETID = B.VENDOR_SETID AND X1.FIELDNAME = 'USER_ACC_STATUS' AND X1.FIELDVALUE = A.USER_ACC_STATUS AND X1.EFF_STATUS = 'A' AND %EffdtCheck(PSXLATITEM X3, X1, %CurrentDateIn) AND X2.FIELDNAME = 'SP_ELIGIBLE_STATUS' AND X2.FIELDVALUE = A.SP_ELIGIBLE_STATUS AND X2.EFF_STATUS = 'A' AND %EffdtCheck(PSXLATITEM X4, X2, %CurrentDateIn)

  • Related Language Record: SPB_PERSSES_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
    2 SPRO_PERSON_TYPE Character(2) VARCHAR2(2) NOT NULL Person Type
    BH=Coordinator/Provider Contact
    PC=Service Provider/Coordinator
    SC=Service Coordinator
    SP=Service Provider
    3 USER_ACC_STATUS Character(4) VARCHAR2(4) NOT NULL Account Status
    0=Inactive
    1=Active
    2=Pending Registration
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
    6 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL Middle Name
    7 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
    8 SP_ELIGIBLE_STATUS Character(1) VARCHAR2(1) NOT NULL Service Provider Eligibility status indicator
    N=No
    Y=Yes
    9 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr
    10 ASOFDATE Date(10) DATE As of Date
    11 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
    12 VENDOR_NAME1 Character(40) VARCHAR2(40) NOT NULL Vendor Name1
    13 ROW_MODIFY_DATE DateTime(26) TIMESTAMP Modified Date Time
    14 SES_LAST_DTTM DateTime(26) TIMESTAMP PTSF Last Modified DateTimestamp