SPA_PERSON_VW(SQL View) |
Index Back |
|---|---|
Service Procurement User TableService Procurement Generic User Table for Fluid Approval |
| SELECT A.BUSINESS_UNIT , A.SHEET_ID , B.PERSON_ID , B.SPRO_PERSON_TYPE , B.USER_ACC_STATUS , B.FIRST_NAME , B.MIDDLE_NAME , B.LAST_NAME , B.NAME , B.TITLE , B.PER_STATUS , B.SSN , B.EMAIL_NOTIFICATION , B.FAX , B.INDP_PROVIDER , B.SP_ELIGIBLE_STATUS , B.ROW_CREATE_DATE , B.ROW_MODIFY_DATE , B.ROW_CREATE_USER , B.ROW_MODIFY_USER , B.SPB_USER_CREATED , B.EMPLID FROM PS_SPA_SHEET_HBUVW A ,PS_SPB_PERSON_TBL B WHERE A.PERSON_ID = b.PERSON_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | SHEET_ID |
Character(10) | VARCHAR2(10) NOT NULL | Report ID |
| 3 | PERSON_ID | Character(15) | VARCHAR2(15) NOT NULL |
Person ID
Default Value: Y |
| 4 | 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 |
| 5 | USER_ACC_STATUS | Character(4) | VARCHAR2(4) NOT NULL |
Account Status
0=Inactive 1=Active 2=Pending Registration Default Value: 1 |
| 6 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 7 | MIDDLE_NAME | Character(30) | VARCHAR2(30) NOT NULL | Middle Name |
| 8 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 9 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 10 | TITLE | Character(35) | VARCHAR2(35) NOT NULL | Title |
| 11 | PER_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Personnel Status
E=Employee N=Non-Employee |
| 12 | SSN | Character(9) | VARCHAR2(9) NOT NULL | Social Security # |
| 13 | EMAIL_NOTIFICATION | Character(1) | VARCHAR2(1) NOT NULL |
Email Notify for Status Change
N=No Y=Yes Default Value: N |
| 14 | FAX | Character(24) | VARCHAR2(24) NOT NULL | Fax Number |
| 15 | 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 |
| 16 | SP_ELIGIBLE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Service Provider Eligibility status indicator
N=No Y=Yes Default Value: Y |
| 17 | ROW_CREATE_DATE | DateTime(26) | TIMESTAMP |
Row Creation Date Time
Default Value: %DateTime |
| 18 | ROW_MODIFY_DATE | DateTime(26) | TIMESTAMP |
Modified Date Time
Default Value: %DateTime |
| 19 | ROW_CREATE_USER | Character(30) | VARCHAR2(30) NOT NULL | Row Added By |
| 20 | ROW_MODIFY_USER | Character(30) | VARCHAR2(30) NOT NULL | Modified User |
| 21 | SPB_USER_CREATED | Character(1) | VARCHAR2(1) NOT NULL |
spro user profile created flag
Y/N Table Edit Default Value: N |
| 22 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSONAL_DATA |