SPB_PERSON_TBL

(SQL Table)
 Index Back

Service Procurement User Table

Service Procurement Generic User Table

  • Parent Record Of SPB_PERS_EMAIL SPB_PERS_PHONE SPB_PROV_SKILLS SPB_SERVICE_COD SPB_SERVICE_PRV SPB_SPCNT_LOC_V SPB_SP_TAO SPB_SRV_PROV_ID

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID

    Default Value: Y

    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

    Default Value: 1

    4 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
    5 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL Middle Name
    6 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
    7 NAME Character(50) VARCHAR2(50) NOT NULL Name
    8 TITLE Character(35) VARCHAR2(35) NOT NULL Title
    9 PER_STATUS Character(1) VARCHAR2(1) NOT NULL Personnel Status
    E=Employee
    N=Non-Employee
    10 SSN Character(9) VARCHAR2(9) NOT NULL Social Security #
    11 EMAIL_NOTIFICATION Character(1) VARCHAR2(1) NOT NULL Email Notify for Status Change
    N=No
    Y=Yes

    Default Value: N

    12 FAX Character(24) VARCHAR2(24) NOT NULL Fax Number
    13 INDP_PROVIDER Character(1) VARCHAR2(1) NOT NULL Field to capture whether the provider is an independent provider

    Y/N Table Edit

    Default Value: N

    14 SP_ELIGIBLE_STATUS Character(1) VARCHAR2(1) NOT NULL Service Provider Eligibility status indicator
    N=No
    Y=Yes

    Default Value: Y

    15 ROW_CREATE_DATE DateTime(26) TIMESTAMP Row Creation Date Time

    Default Value: %DateTime

    16 ROW_MODIFY_DATE DateTime(26) TIMESTAMP Modified Date Time

    Default Value: %DateTime

    17 ROW_CREATE_USER Character(30) VARCHAR2(30) NOT NULL Row Added By
    18 ROW_MODIFY_USER Character(30) VARCHAR2(30) NOT NULL Modified User
    19 SPB_USER_CREATED Character(1) VARCHAR2(1) NOT NULL spro user profile created flag

    Y/N Table Edit

    Default Value: N

    20 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSONAL_DATA