GM_PERSONAL3_VW(SQL View) |
Index Back |
|---|---|
Grants Personal Data View 3PERSONAL_DATA is one of the core records in the database. Use it to record personal and demographic data about an employee or applicant including name, address, birthdate, and ethnic group. View of Personal Data because we can only have one related display from a record for each panel. |
| SELECT A.EMPLID , A.EFFDT , A.UPDATE_PERS_DATA , %subrec(ADDRESS_SBR,A) , A.ADDRESS1_AC , A.ADDRESS2_AC , A.ADDRESS3_AC , A.CITY_AC , %subrec(ADDR_OTR_SBR,A) , A.MAR_STATUS , A.SMOKER , %subrec(NAMEGBL_SBR,A) FROM PS_PERS_DATA_EFFDT A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EFFDT |
Date(10) | DATE | Effective Date |
| 3 | UPDATE_PERS_DATA | Character(1) | VARCHAR2(1) NOT NULL | Update Personal Data |
| 4 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: COUNTRY_TBL |
| 5 | ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
| 6 | ADDRESS2 | Character(55) | VARCHAR2(55) NOT NULL | Address 2 |
| 7 | ADDRESS3 | Character(55) | VARCHAR2(55) NOT NULL | Address 3 |
| 8 | ADDRESS4 | Character(55) | VARCHAR2(55) NOT NULL | Address 4 |
| 9 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 10 | NUM1 | Character(6) | VARCHAR2(6) NOT NULL | Number 1 |
| 11 | NUM2 | Character(6) | VARCHAR2(6) NOT NULL | Number 2 |
| 12 | HOUSE_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
House Type
AB=House Boat WW=Trailer |
| 13 | ADDR_FIELD1 | Character(2) | VARCHAR2(2) NOT NULL | Address Field 1 |
| 14 | ADDR_FIELD2 | Character(4) | VARCHAR2(4) NOT NULL | Address Field 2 |
| 15 | ADDR_FIELD3 | Character(4) | VARCHAR2(4) NOT NULL | Address Field 3 |
| 16 | COUNTY | Character(30) | VARCHAR2(30) NOT NULL | County |
| 17 | STATE | Character(6) | VARCHAR2(6) NOT NULL |
State
Prompt Table: %EDIT_STATE |
| 18 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
| 19 | GEO_CODE | Character(11) | VARCHAR2(11) NOT NULL | Geo Code |
| 20 | IN_CITY_LIMIT | Character(1) | VARCHAR2(1) NOT NULL |
In City Limit
Y/N Table Edit |
| 21 | ADDRESS1_AC | Character(55) | VARCHAR2(55) NOT NULL | Alternate Character Address 1 |
| 22 | ADDRESS2_AC | Character(55) | VARCHAR2(55) NOT NULL | Alternate Character Address 2 |
| 23 | ADDRESS3_AC | Character(55) | VARCHAR2(55) NOT NULL | Alternate Character Address 3 |
| 24 | CITY_AC | Character(30) | VARCHAR2(30) NOT NULL | Alternate Character City |
| 25 | COUNTRY_OTHER | Character(3) | VARCHAR2(3) NOT NULL |
Country field for ADDR_OTR_SBR and DERIVED_ADDR_OT
Prompt Table: COUNTRY_TBL |
| 26 | ADDRESS1_OTHER | Character(55) | VARCHAR2(55) NOT NULL | Address 1 Other |
| 27 | ADDRESS2_OTHER | Character(55) | VARCHAR2(55) NOT NULL | Address 2 Other |
| 28 | ADDRESS3_OTHER | Character(55) | VARCHAR2(55) NOT NULL | Address 3 Other |
| 29 | ADDRESS4_OTHER | Character(55) | VARCHAR2(55) NOT NULL | Address 4 Other |
| 30 | CITY_OTHER | Character(30) | VARCHAR2(30) NOT NULL | City Other |
| 31 | COUNTY_OTHER | Character(30) | VARCHAR2(30) NOT NULL | County Other |
| 32 | STATE_OTHER | Character(6) | VARCHAR2(6) NOT NULL |
State Other
Prompt Table: %EDIT_STATE_OTH |
| 33 | POSTAL_OTHER | Character(12) | VARCHAR2(12) NOT NULL | Postal Other |
| 34 | NUM1_OTHER | Character(6) | VARCHAR2(6) NOT NULL | Number 1 Other |
| 35 | NUM2_OTHER | Character(6) | VARCHAR2(6) NOT NULL | Number 2 Other |
| 36 | HOUSE_TYPE_OTHER | Character(2) | VARCHAR2(2) NOT NULL |
House Type Other
AB=House Boat Reference WW=House Trailer Reference |
| 37 | ADDR_FIELD1_OTHER | Character(2) | VARCHAR2(2) NOT NULL | Address Field 1 Other |
| 38 | ADDR_FIELD2_OTHER | Character(4) | VARCHAR2(4) NOT NULL | Address Field 2 Other |
| 39 | ADDR_FIELD3_OTHER | Character(4) | VARCHAR2(4) NOT NULL | Address Field 3 Other |
| 40 | IN_CITY_LMT_OTHER | Character(1) | VARCHAR2(1) NOT NULL | In City Limit Other |
| 41 | GEO_CODE_OTHER | Character(11) | VARCHAR2(11) NOT NULL | Geo Code Other |
| 42 | MAR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Marital Status
C=Common-Law D=Divorced E=Separated H=Head of Household M=Married S=Single U=Unknown W=Widowed |
| 43 | SMOKER | Character(1) | VARCHAR2(1) NOT NULL | Smoker |
| 44 | COUNTRY_NM_FORMAT | Character(3) | VARCHAR2(3) NOT NULL |
Format for Country
Prompt Table: COUNTRY_TBL |
| 45 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 46 | NAME_INITIALS | Character(6) | VARCHAR2(6) NOT NULL | Name Initials |
| 47 | NAME_PREFIX | Character(4) | VARCHAR2(4) NOT NULL |
Name Prefix
1=Mr. 2=Mrs. 3=Ms. Prompt Table: NAME_PREFIX_TBL |
| 48 | NAME_SUFFIX | Character(15) | VARCHAR2(15) NOT NULL |
Name Suffix
Prompt Table: NAME_SUFFIX_TBL |
| 49 | NAME_ROYAL_PREFIX | Character(15) | VARCHAR2(15) NOT NULL | Name Royal Prefix |
| 50 | NAME_ROYAL_SUFFIX | Character(15) | VARCHAR2(15) NOT NULL | Name Royal Suffix |
| 51 | NAME_TITLE | Character(30) | VARCHAR2(30) NOT NULL | Title |
| 52 | LAST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 53 | FIRST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 54 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 55 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 56 | MIDDLE_NAME | Character(30) | VARCHAR2(30) NOT NULL | Middle Name |
| 57 | SECOND_LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Second Last Name |
| 58 | SECOND_LAST_SRCH | Character(30) | VARCHAR2(30) NOT NULL | Second Name |
| 59 | NAME_AC | Character(50) | VARCHAR2(50) NOT NULL | Alternate Character Name |
| 60 | PREF_FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Preferred First Name |