SCC_PERDATA_QVW - PERSONAL_DATA Query View

Body

SCC_PERDATA_QVW is a view of PERSONAL_DATA table. Since PERSONAL_DATA is not available in PS Query, use this view for reporting.

Detailed Information

Data Systems

PeopleSoft Campus Solutions - CSPRD
PeopleSoft Campus Solutions Reporting - CSRPT

 

View SQL Build Code

Download SQL Build Code

 

Key Record.Fieldname Format XLAT Heading Text
  ADDRESS1 - Address Line 1 Char55   Address 1
  ADDRESS1_AC - Alternate Character Address Char55   AC Address 1
  ADDRESS1_OTHER - Address Line 1 Char55   Address 1
  ADDRESS2 - Address Line 2 Char55   Address 2
  ADDRESS2_AC - Alternate Character Address 2 Char55   AC Address 2
  ADDRESS2_OTHER - Address Line 2 Char55   Address 2
  ADDRESS3 - Address Line 3 Char55   Address 3
  ADDRESS3_AC - Alternate Character Address 3 Char55   AC Address 3
  ADDRESS3_OTHER - Address Line 3 Char55   Address 3
  ADDRESS4 - Address Line 4 Char55   Address 4
  ADDRESS4_OTHER - Address Line 4 Char55   Address 4
  ADDR_FIELD1 - Address Field 1 Char2 N Address Field 1
  ADDR_FIELD1_OTHER - Address Field 1 Char2 N Address Field 1
  ADDR_FIELD2 - Address Field 2 Char4   Address Field 2
  ADDR_FIELD2_OTHER - Address Field 2 Char4   Address Field 2
  ADDR_FIELD3 - Address Field 3 Char4   Address Field 3
  ADDR_FIELD3_OTHER - Address Field 3 Char4   Address Field 3
  ALTER_EMPLID - Alternate Employee ID Char11   Alternate ID
  BARG_UNIT - Bargaining Unit Char4 N Barg Unit
  BILINGUALISM_CODE - Bilingualism Code Char1 N Bilingual
  BIRTHCOUNTRY - Birth Country Char3   Country
  BIRTHDATE - Date of Birth Date   Birthdate
  BIRTHPLACE - Birth Location Char30   Birthplace
  BIRTHSTATE - Birth State Char6   State
  CAMPUS_ID - Campus ID Char16   Campus ID
  CITIZEN_PROOF1 - Citizenship (Proof 1) Char10   Citizen 1
  CITIZEN_PROOF2 - Citizenship (Proof 2) Char10   Citizen 2
  CITY - City Char30   City
  CITY_AC - Alternate Character City Char30   AC City
  CITY_OTHER - City - Other Char30   City
  COUNTRY - Country Char3   Country
  COUNTRY_CODE - Country Code Char3   Country
  COUNTRY_NM_FORMAT - Format Using Char3   Use
  COUNTRY_OTHER - Country - Other Char3   Country
  COUNTY - County Char30   County
  COUNTY_OTHER - County - Other Char30   County
  CPAMID - CPAM ID Char6   CPAMID
  DEATH_CERTIF_NBR - Death Certificate Nbr Char10   Certif Nbr
  DISABLED - Disabled Char1   Disabled
  DISABLED_VET - Disabled Veteran Char1   Disab Vet
  DT_OF_DEATH - Date of Death Date   Death Date
Key EMPLID - Empl ID Char11   ID
  ENTRY_DT_FRA - Date of First Entry in France Date   Entry Dt
  EXPCTD_MILITARY_DT - Expected Military Date Date   Expctd MDt
  EXTENSION - Phone Extension Char6   Ext
  FERPA - FERPA Char1   FERPA
  FIRST_NAME - First Name Char30   First Name
  FIRST_NAME_SRCH - First Name Char30   First Name
  FT_STUDENT - Full-Time Student Char1   FT Student
  GEO_CODE - Tax Vendor Geographical Code Char11   Geo Code
  GEO_CODE_OTHER - Geo Code Other Char11   Geo Cd Other
  GRADE - Salary Grade Char3   Grade
  GVT_CHANGE_FLAG - Change Flag Char1   Chnge Flag
  GVT_CRED_MIL_SVCE - Creditable Military Service Char4   Cred Milty
  GVT_CURR_AGCY_EMPL - Current Agency Employee Char1   CurrAgcyEm
  GVT_CURR_FED_EMPL - Current Federal Employee Char1   CurrFedEmp
  GVT_DISABILITY_CD - Disability Code Char2   Disability Cd
  GVT_DRAFT_STATUS - Draft Status Char1 N Draft Sts
  GVT_HIGH_GRADE - Highest Grade Char3   Grade
  GVT_HIGH_PAY_PLAN - Highest Pay Plan Char2   Highest PP
  GVT_MILITARY_COMP - Uniformed Service Char1 N Component
  GVT_MIL_GRADE - Military Grade Char3 N Mil Grade
  GVT_MIL_RESRVE_CAT - Reserve Category Char1 N Resrve Cat
  GVT_MIL_SEP_RET - Military Separation Status Char1 N Sep Status
  GVT_MIL_SVCE_END - Military Service End Date Date   End Date
  GVT_MIL_SVCE_START - Military Service Start Date Date   Start Date
  GVT_MIL_VERIFY - Military Service Verified Char1   Svce Verf
  GVT_PAR_NBR_LAST - Last Personnel Action Reqst # Num6.0   Last PAR#
  GVT_PAY_PLAN - Pay Plan Char2   Pay Plan
  GVT_PREV_AGCY_EMPL - Previous Agency Employee Char1   PrevAgcyEm
  GVT_PREV_FED_EMPL - Previous Federal Employee Char1   PrevFedEmp
  GVT_SEP_INCENTIVE - Separation Incentive Char1 N Incentive
  GVT_SEP_INCENT_DT - Separation Incentive Date Date   Date
  GVT_TENURE - Highest Career Tenure Char1 N Tenure
  GVT_UNIF_SVC_CTR - Notify Military Pay Center Char1   SvcPayCtr
  GVT_VET_PREF_APPT - Veterans Preference Char1   Veterans Pref
  GVT_VET_PREF_RIF - Veterans Preference RIF Char1   Pref RIF
  GVT_YR_ATTAINED - Year Attained Date   Year
  HEALTH_CARE_NBR - Health Care Number Char12   Health#
  HEALTH_CARE_STATE - Health Care Province Char6   Hlth Prov
  HIGHEST_EDUC_LVL - Highest Education Level Char2 N Hi Educ Lv
  HONSEKI_JPN - Honseki Prefecture Char2   Honseki
  HOUSE_TYPE - House Type Char2 N House
  HOUSE_TYPE_OTHER - House Type Other Char2 N House Other
  HR_RESPONSIBLE_ID - HR Responsible ID Char11   HR ID
  IN_CITY_LIMIT - In City Limit Char1   In Cty Lmt
  IN_CITY_LMT_OTHER - In City Limit Other Char1   In Cty Lt Other
  LANG_CD - Language Code Char3 N Lang Cd
  LASTUPDDTTM - Last Update Date/Time DateTm   Last Upd DtTm
  LAST_NAME - Last Name Char30   Last
  LAST_NAME_PREF_NLD - Last Name Preference Char1 N Preference
  LAST_NAME_SRCH - Last Name Char30   Last
  MAR_STATUS - Marital Status Char1 N Mar Status
  MAR_STATUS_DT - Marital Status Date Date   Mar StatDt
  MEDICARE_ENTLD_DT - Date Entitled to Medicare Date   Medcare Dt
  MIDDLE_NAME - Middle Name Char30   Middle
  MILITARY_END_ITA - Military End Date Date   End Date
  MILITARY_RANK_ITA - Function or Rank Char50   Function/Rank
  MILITARY_STATUS - Military Status Char1 N Mil Status
  MILITARY_STAT_GER - Military Status Char1 N Military Status
  MILITARY_STAT_ITA - Military Status Italy Char1 N Military Status
  MILITARY_TYPE_ITA - Type of Service Char2 N Type of Service
  MILIT_SITUATN_ESP - Military Status Char3 N Military
  MILIT_SITUATN_FRA - Military Status Char3 N Military
  NAME - Name Char50   Name
  NAME_AC - Alternate Character Name Char50   AC Name
  NAME_DISPLAY - Display Name Char50   Display Name
  NAME_FORMAL - Formal Name Char60   Formal Name
  NAME_INITIALS - Name Initials Char6   Initials
  NAME_PREFIX - Name Prefix Char4   Prefix
  NAME_ROYAL_PREFIX - Name Royal Prefix Char15   Royal Prefix
  NAME_ROYAL_SUFFIX - Name Royal Suffix Char15   Royal Suffix
  NAME_SUFFIX - Name Suffix Char15   Suffix
  NAME_TITLE - Title Char30   Title
  NUM1 - Number 1 Char6   Nbr 1
  NUM1_OTHER - Number 1 Other Char6   Nbr 1 Other
  NUM2 - Number 2 Char6   Nbr 2
  NUM2_OTHER - Number 2 Other Char6   Nbr 2 Other
  PARTNER_LAST_NAME - Last Name Partner Char30   Last Name
  PARTNER_ROY_PREFIX - Prefix Partner Char15   Prefix
  PHONE - Telephone Char24   Phone
  PLACE_OF_DEATH - Place of Death Char30   Death Plce
  POSTAL - Postal Code Char12   Postal
  POSTAL_OTHER - Postal Code - Other Char12   Postal
  PREF_FIRST_NAME - Preferred First Name Char30   Preferred First
  SAL_ADMIN_PLAN - Salary Administration Plan Char4   Sal Plan
  SECOND_LAST_NAME - Second Last Name Char30   Second Last
  SECOND_LAST_SRCH - Second Name Char30   Second Name
  SEX - Gender Char1 N Sex
  SMOKER - Smoker Char1   Smoker
  SMOKER_DT - Smoker Date Date   Smoker Date
  SOC_SEC_AFF_DT - Social Security Affiliation Dt Date   Soc.SecAff.Dt
  STATE - State Char6   State
  STATE_OTHER - State - Other Char6   State
  US_WORK_ELIGIBILTY - Eligible to Work in U.S. Char1   US Wk Elig
  VA_BENEFIT - VA Benefit Char1   VA Benefit

Back to Top

Back to Top

Details

Details

Article ID: 158846
Created
Fri 5/10/24 4:26 AM
Modified
Fri 8/23/24 4:39 PM
Applies To
Faculty
Staff
Community

Related Services / Offerings

Related Services / Offerings (1)

DARTS (UMS Data) Inquiry
Submit an inquiry about UMS Data (except Data Governance)

Attachments

Attachments (1) Sort By: Sort Attachments ByName Sort Attachments ByDate

txt

SCC_PERDATA_QVW.txt Computer

Fri 8/23/24 4:36 PM
View
;