OPRCLASSBUSINESS_UNITDefault Value: OPR_DEF_TBL_CS.BUSINESS_UNIT
Prompt Table: SP_BU_SF_NONVW
EMPLIDDefault Value: NEW
Prompt Table: PEOPLE_SRCH
F=Female
M=Male
U=Unknown
X=Indeterminate/Intersex/Unspec
PEOPLE_SRCH_SF(SQL View) |
Index Back |
|---|---|
People Search SF ViewCommon view used when searching for/selecting a person for display/update. This view should be used as the basis for all other views which go against people. The PeopleCode contained on this view is important for any other view which is based on this one - the searching/formatting for names and setting the carry id is done with this code. |
| SELECT C.OPRCLASS ,A.BUSINESS_UNIT ,A.EMPLID ,SUM(A.ACCOUNT_BALANCE) ,C.COUNTRY ,C.NATIONAL_ID_TYPE ,D.DESCRSHORT ,C.NATIONAL_ID ,C.NATIONAL_ID_MSK ,F.BIRTHDATE ,F.BIRTHDATE_MSK ,G.SEX ,B.NAME ,E.CAMPUS_ID ,B.LAST_NAME_SRCH ,B.FIRST_NAME_SRCH FROM PS_ACCOUNT_SF A ,PS_SCC_PRI_NAME_VW B ,PS_PERS_NID_MSK_VW C ,PS_NID_TYPE_TBL D ,PS_SCC_PERS_SA_VW E ,PS_PERSON_MSK_VW F ,PS_HCR_PER_PDE_I G WHERE A.EMPLID = B.EMPLID AND A.EMPLID = C.EMPLID AND A.EMPLID = E.EMPLID AND D.COUNTRY = C.COUNTRY AND D.NATIONAL_ID_TYPE = C.NATIONAL_ID_TYPE AND A.EMPLID = F.EMPLID AND C.OPRCLASS = F.OPRCLASS AND A.EMPLID = G.EMPLID AND G.EFFDT = ( SELECT MAX(G1.EFFDT) FROM PS_HCR_PER_PDE_I G1 WHERE G1.EMPLID=G.EMPLID AND G1.EFFDT<=%CurrentDateIn) GROUP BY C.OPRCLASS ,A.BUSINESS_UNIT ,A.EMPLID ,C.COUNTRY ,C.NATIONAL_ID_TYPE ,D.DESCRSHORT ,C.NATIONAL_ID ,C.NATIONAL_ID_MSK ,F.BIRTHDATE ,F.BIRTHDATE_MSK ,G.SEX ,B.NAME ,E.CAMPUS_ID ,B.LAST_NAME_SRCH ,B.FIRST_NAME_SRCH |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRCLASS |
Character(30) | VARCHAR2(30) NOT NULL | Operator Class |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_CS.BUSINESS_UNIT Prompt Table: SP_BU_SF_NONVW |
| 3 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Default Value: NEW Prompt Table: PEOPLE_SRCH |
| 4 | ACCOUNT_BALANCE | Signed Number(18,2) | DECIMAL(16,2) NOT NULL | Account Balance |
| 5 | NID_COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | National ID Country |
| 6 | NATIONAL_ID_TYPE | Character(6) | VARCHAR2(6) NOT NULL | National ID Type |
| 7 | NID_DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | NID Short Description |
| 8 | NATIONAL_ID | Character(20) | VARCHAR2(20) NOT NULL | National ID |
| 9 | NATIONAL_ID_MSK | Character(20) | VARCHAR2(20) NOT NULL | National ID |
| 10 | BIRTHDATE | Date(10) | DATE | Date of Birth |
| 11 | BIRTHDATE_MSK | Character(10) | VARCHAR2(10) NOT NULL | Date of Birth |
| 12 | SEX | Character(1) | VARCHAR2(1) NOT NULL |
Gender
F=Female M=Male U=Unknown X=Indeterminate/Intersex/Unspec |
| 13 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 14 | CAMPUS_ID | Character(16) | VARCHAR2(16) NOT NULL | Campus ID |
| 15 | LAST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 16 | FIRST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | First Name |