PERSON (SQL Table)	Index Back
PERSON record PERSON one of the core records in the database. It contains one row for every Person (EMPLID) in the system. It is the Parent record or PERS_DATA_EFFDT, EMPLOYMENT etc. You can create only one PERSONAL_DATA record per person.

PERSON

(SQL Table)

PERSON record

PERSON one of the core records in the database. It contains one row for every Person (EMPLID) in the system. It is the Parent record or PERS_DATA_EFFDT, EMPLOYMENT etc. You can create only one PERSONAL_DATA record per person.

Parent Record Of ACCOMPLISHMENTS ACCOMPLISHMT_VW ADDRESSES ADDRESSES_CV ADDRESS_DEL_WR ADDRESS_NPC_VW ADDRESS_SWIT_FL ADDRESS_TYPE_CV ADDRESS_TYPE_FL ADDRESS_TYPE_V2 ADDRESS_TYPE_VW ADDRESS_TYPE_WR ADDR_CURR_VW ADDR_ORDER_VW ASGN_CMP_EFFDT ASSGNMT_LNG ASSIGNMENT ASSIGNMENT_SRCH ASSIGNMENT_VW AUDIOMETRIC_LNG AUDIOMETRIC_TST AUDIO_TST_LANG BAL_ADJ_ARR BAL_ADJ_CHK BAL_ADJ_CN_CHK BAL_ADJ_CN_DED BAL_ADJ_CN_TAX BAL_ADJ_DED BAL_ADJ_GRN BAL_ADJ_TAX BAL_ADJ_UI_CAN BEN_BI_DETAIL BEN_QRY_AGE16VW BN_COUNTRY_DFLT BN_PERSON BOND_LOG BOND_TMP_VW BUS_EXPENSE_PER CAN_CHECK_YTD CAN_CHK_YTD_VW CAN_DED_BALANCE CAN_DED_BAL_VW CAN_DED_SUM_VW CAN_ERN_BAL_VW CAN_ERN_SUM_VW CAN_TAX_BALANCE CAN_TAX_BAL_VW CAN_TAX_DATA CAREERPLAN CAREERPLAN_CURR CHECK_YTD CHECK_YTD_VW CITIZENSHIP CM_CATGRY_VW_LN CM_EE_COMP_TRN CM_EE_NC_ITM_VW CM_EVALUATIONS COMMUNICATION COMM_CATEGRY_VW COMPETENCIES_A COMPETENCY_DVLP COMPETENCY_STR COMP_PROP CO_PERSPHN_VW DEDUCTION_BAL DED_ARREARS DED_ARR_SUM_VW DED_BAL_CALC_VW DED_BAL_SUM_VW DED_BAL_VW DEPENDENT_BENEF DEPEND_BEN_LNG DEPEND_VW1_LNG DEPEND_VW_LNG DEP_BEN DEP_BEN_EFF_LNG DEP_BEN_LNG DEP_BEN_VW1 DIRECT_DEPOSIT DISABILITY DISABILITY_V1 DISABILITY_V2 DISABILITY_V3 DISABILITY_V4 DISABILITY_V5 DISCIPLIN_ACTN DISCIP_ACT_LNG DRIVERS_LIC DRIVER_LIS_LANG DSADDR_EFF_VW DSNAMES_EFF_VW EMAIL_ADDRESSES EMAIL_ADDR_CV EMERGENCY_CNTCT EMERGNCY_CNT_VW EMG_CNTCT_NM_VW EMPLOYMENT_LNG2 EMPLOYMENT_LNG3 EMPL_PHOTO EMPL_PH_RZ_VW EP_REVWR_ID_VW ERN_BAL_SUM_VW ERN_BAL_VW EYE_EXAM FED_TAX_DATA FE_EMPL_PROMPT FE_NAME_PROMPT FMLA_LV_REQUEST FMLY_HOST_EFFDT FPAADDRS_HIST FPANAMES_HIST FPANAMES_HISTVW FPAPEREFFDT_HIS FPAPERS_NID_HIS FSA_SUMMARY FT_ORG_ASGN FT_ORG_INST FT_PEREML_TAO FT_PERPHN_TAO FT_PERSON_PHONE FT_PERS_DAT_EFF FT_PER_EMAIL GARN_BALANCE GARN_SPEC GARN_SPEC_STG GENL_CMNT_LNG GENL_COMMENT GPBR_ES_EMPL_VW GPBR_ES_EMP_VW GPBR_ES_E_PH_VW GPCH_AL_EMPLMT GPCH_TX_LAWDATA GPDE_AL_EMPLMT GPDE_RP_0001 GPDE_RP_0001VW1 GPDE_RP_0001_VW GPDE_RP_001_HST GPDE_RP_DTHB_EE GPDE_RP_DTH_HST GPDE_RP_SI01 GPDE_RP_SI01_VW GPDE_RP_SI1_HST GPDE_RP_VBD_TMP GPDE_RP_VBEZ_EE GPDE_RP_VBZ_HST GPES_EXPT_ADDR GPES_PERSPOI_VW GPES_PP_SRC_VW GPGB_EE_CO_HDR GPJP_EFILE_VW GPJP_EFIL_TAO GPJP_EFLE_16_VW GPJP_EFLE_20_VW GPJP_IH_PYE_TAX GPJP_IT_PYE_TAX GPJP_YEA_PYEADJ GPJP_YEA_TABLE GPJP_YS10_TAO GPJP_YS11_TAO GPJP_YS12_TAO GPJP_YSS2_TAO GPJP_YSS3_TAO GPJP_YSS4_TAO GPJP_YSS5_TAO GPJP_YSS6_TAO GPJP_YSS7_TAO GPJP_YSS8_TAO GPJP_YSS9_TAO GPNL_EMPLRCD_VW GPNL_PAYEE_ADD GPNZ_EE_IRD_NUM GPSG_CITIZENSHP GPSG_NID_TAX_VW GPS_CHILD_ALLW GPTH_DIS_ADD_VW GPTH_DIS_NM_VW GPTH_PERSON_NM GPTH_PER_ADDR GP_ERC_NAMES GP_POI_VW GP_PSLP_PERS_NM GVT_BOND_TMP_VW GVT_DRUG_TEST GVT_DRUG_T_LANG GVT_EMPLOY_LANG GVT_EMP_PUSH_VW GVT_GARN_SPEC GVT_GARN_SP_STG GVT_HEALTH_CARD GVT_HEALTH_DRUG GVT_HEALTH_TEST GVT_NID_PUSH_VW GVT_PAYROLL_DTA GVT_PD_EFDT_PSH GVT_PERS_NID GVT_PPH_PUSH_VW GVT_PYLM_BAL_VW GVT_PYLM_LT_VW GVT_PYLM_SUM_VW HCDL_FNAME_DVW HCDL_FNAME_VW HCDL_FNAM_VW HCDL_LNAME_DVW HCDL_LNAME_VW HCDL_LNAM_VW HCDL_NAME_SRCH HCDL_PROXY_SRCH HCR_ADDRESSES_I HCR_AUDMTRC_LNI HCR_AUDMT_TST_I HCR_CITIZSHIP_I HCR_DISABL_I HCR_DRVRS_LIC_I HCR_EMAIL_ADD_I HCR_EMERG_CNT_I HCR_EMPL_PHOT_I HCR_EYE_EXAM_I HCR_NAMES_I HCR_NAMES_I_LNG HCR_OC_PRO_VW HCR_ORG_INST_VW HCR_PERSDAT_E_I HCR_PERSN_PHN_I HCR_PERSON_NM_I HCR_PERSON_VW_I HCR_PERS_DTA_I HCR_PER_ADDR_I HCR_PER_CAN_I HCR_PER_EMAIL_I HCR_PER_NAME_I HCR_PER_NID_I HCR_PER_ORG_A_I HCR_PER_PDE_I HCR_PER_PHONE_I HCR_PER_USA_I HCR_PHYSIC_EX_I HCR_PHYS_EX_LNI HCR_RESP_EXM_I HCR_RESP_EX_LNI HCR_SCC_PR_NM_I HCSC_EM_ADDR_VW HCSC_EM_PHN_VW HCTS_INTPRFL_VW HCTS_INTPRF_LVW HD_360_EMAIL_WK HD_360_EMGCY_WK HD_360_PHNE_WK HRCD_USER_PHOTO HRS_ACT_MGR_LN HRS_ACT_MGR_VW HRS_ACT_PERS_I HRS_ACT_PERS_I1 HRS_ACT_PERS_L1 HRS_ACT_PERS_LN HRS_ACT_PRS_LN2 HRS_ACT_PRS_LN3 HRS_ACT_PRS_LN4 HRS_ACT_PRS_VW2 HRS_ACT_PRS_VW3 HRS_ACT_PRS_VW4 HRS_ACT_RCTR_I HRS_ACT_RCTR_LN HRS_ACT_RECR_LN HRS_ACT_RECR_VW HRS_APP_INFO_I HRS_EE_EMAIL HRS_EE_PHONE HRS_EMPL_NM_I HRS_EMPL_NM_LNG HRS_PERSD_DEU_I HRS_PERSD_ESP_I HRS_PERSD_FRA_I HRS_PERSD_ITA_I HRS_PERSD_JPN_I HRS_PERSON_NM_I HRS_PERSON_NM_L HRS_PERS_NM_VW HRS_PER_EMAIL_I HRS_PER_ORG_A_I HRS_PKG_NAME_I HRS_RECR_PERS_I HRS_REC_NM_I HRS_REC_NM_LNG HR_ADDRAC_CHG_V HR_ADDR_APVL_VW HR_ADDR_CHG_DAT HR_ADDR_CHG_FMT HR_ADDR_DAT_VW HR_ADDR_DAT_VW2 HR_ADDR_DAT_VW3 HR_ADDR_DTL_VW HR_ADDR_PNDG HR_CP_EDUC2_VW HR_CP_EDUC_VW HR_CP_GEOG_VW HR_CP_GEO_PREF HR_CP_HONAW_VW HR_CP_INTL_PREF HR_CP_INTL_VW HR_CP_LANG_VW HR_CP_LANG_WRK HR_CP_LICERT_VW HR_CP_LOCPRF_VW HR_CP_LOC_PREF HR_CP_LOC_VW HR_CP_MEMB_VW HR_CP_MOBIL2_VW HR_CP_MOBILITY HR_CP_MOBIL_VW HR_CP_MOBIL_WRK HR_CP_PLAN HR_CP_SPCPRJ_VW HR_CP_TEST_VW HR_CP_TRAV_VW HR_EM_ADDRS_VW HR_NAME_RTI_LN1 HR_NAME_RTI_LVW HR_NAME_WF_SS HR_NM_WFSSLNG HR_PERS_FR_VW HR_PERS_US_VW HR_PER_ORG_SRCH HR_PRSNL_PHN_VW HR_RWHOMADDR_VW HR_RWOTHADDR_VW HR_RW_PADDR_HOM HR_RW_PADDR_LVW HR_SP_MOBILITY HR_SRCH_ADDR HR_SRCH_CP_VW HR_SRCH_NID_LNG HR_SS_PERNM_SRC HR_USER_PHOTO HS_PERSON_SRCH INS_EARNS_BAL INS_EARN_CAN_VW INTL_SCHPGM JOB_DATE_VW JOB_PER_ORG_VW JPM_INTEREST JPM_INTEREST_VW JPM_INTEREST_WK JPM_NO_COMP_VW MODEL_FED_TAX NAMES NAMES_CV NAMES_LNG NAMES_SS_TMP NAME_ALL_VW NAME_ALL_VW_LNG NAME_TYPE_CV NAME_TYPE_VW NAME_TYPE_VW2 NVQ_EMPLELEMENT NVQ_EMPLEL_LNG NVQ_REVIEW NVQ_REVIEW_LNGX NVQ_UNITSPR_LNG NVQ_UNITS_PROG NVQ_UNIT_COM_VW ORIG_HIRE_VW ORIG_HIRE_VW2 ORIG_HIR_CWR_VW ORIG_HIR_EMP_VW ORIG_HIR_PER_VW PAYROLL_DATA PAYROLL_DAT_LNG PA_GENL_COMMENT PCMP_MGRSUP_LNG PD_ADDRESS_VW PERSDATA_CAN_CV PERSDATA_CHE_CV PERSDATA_DEU_CV PERSDATA_EFF_CV PERSDATA_ESP_CV PERSDATA_FPS_CV PERSDATA_FRA_CV PERSDATA_IND_CV PERSDATA_ITA_CV PERSDATA_JPN_CV PERSDATA_MEX_CV PERSDATA_USA_CV PERSONAL_DATA PERSONAL_DATTMP PERSONAL_DTALNG PERSONAL_DTA_VW PERSONAL_DT_FST PERSONAL_DT_V1 PERSONAL_DT_WRK PERSONAL_PHONE PERSONAL_VW PERSONNEL_RPT PERSONNEL_TAO PERSON_ADDRESS PERSON_ADDROTH PERSON_ADDR_HOM PERSON_ADDR_LNG PERSON_ADDR_SS PERSON_ADDR_SS1 PERSON_BRA PERSON_BRA_CV PERSON_DTA_SRCH PERSON_EE_ADDR PERSON_EMAIL PERSON_FRA PERSON_FRA_CV PERSON_HOMEADDR PERSON_INFO_BRA PERSON_MAILADDR PERSON_NAME PERSON_NAME_LNG PERSON_NAME_LVW PERSON_NAME_SS PERSON_NAME_SS1 PERSON_NM PERSON_NMLNG PERSON_NMSS1LNG PERSON_PHONE PERSON_POI_VW PERSON_PRINAME PERSON_PRINMLNG PERS_ADDR_BUSN PERS_ADDR_WF_SS PERS_APPL_INFO PERS_APPL_NAME PERS_APPL_NMLNG PERS_APPL_REF PERS_DATA_CAN PERS_DATA_CHE PERS_DATA_DEU PERS_DATA_EFFDT PERS_DATA_ESP PERS_DATA_FPS PERS_DATA_FRA PERS_DATA_IND PERS_DATA_ITA PERS_DATA_JPN PERS_DATA_MEX PERS_DATA_USA PERS_DATA_US_VW PERS_DATA_WRK PERS_EFFFRA_HIS PERS_EFF_FPSHIS PERS_EMAIL_BS_V PERS_EMAIL_BUSN PERS_HUKOU_CHN PERS_NAME_PRF PERS_NAME_PRI PERS_NAME_WF_SS PERS_NATIVE_CHN PERS_NID PERS_NID_CV PERS_NID_MSK_VW PERS_NID_PRM_VW PERS_NID_V PERS_NID_VW1 PERS_NID_VW2 PERS_NM_WFSSLNG PERS_PHONE_BS_V PERS_PHONE_BUSN PERS_PHONE_CELL PERS_PHONE_CV PERS_PHONE_FAX PERS_PHONE_HOME PERS_PHONE_PGR1 PERS_PHONE_VW PERS_POI_ESP_VW PERS_POLITY_CHN PERS_SMOKER PERS_SMOKER_CV PERS_SMOKER_VW PERS_SMOKER_VW2 PERS_SMOKER_VW3 PERS_SMOKER_VW4 PERS_SOC_MEDIA PERS_STUDENT_VW PERS_USA_WRK PERS_WLF_CHN_CV PERS_WRKLIF_CHN PER_ASGN_CWR_VW PER_ASGN_EMP_VW PER_ASGN_POI_VW PER_CHECKLIST PER_CHECK_LANG PER_INST_CWR_VW PER_INST_EMP_VW PER_INST_POI_VW PER_ORG_ASGN PER_ORG_ASGN_VW PER_ORG_AVW_LNG PER_ORG_INST PER_ORG_OWS_VW PER_ORG_OWS_VWL PER_POI_TYPE PHYSICAL_EXAM PHYS_EXAM_LANG POI_001_VW POI_CBR_VW POI_CS1_VW POI_CS2_VW POI_ENE_VW POI_OTH_VW POI_PA_VW POI_ST1_VW POI_ST2_VW POI_TRN1_VW POI_TRN2_VW POI_UNK_VW PRIORWORK_EXPER PRIORWORK_SUM PRIORWRK_EX_LNG PY_IC_PI_GBL_VW PY_IC_W2_AUDIT PY_IC_W4_AUDIT PY_IC_W4_FTX_VW RESPIRATORY_EXM RESPIR_EXAM_LNG REVIEWER_NM_LW REVIEWER_NM_VW ROE RW_PER_HADDR SAVINGS_403B_EE SAVINGS_MGT_EE SCC_CUR_NAME_VW SCC_CUR_NM_VW2 SCC_MEMBERSHP_H SCC_NM_TYPE2PVW SCC_NM_TYPE_PVW SCC_PDE_CAN_H SCC_PERS_PHONE SCC_PREF_EMAIL SCC_PRI_NAME_VW SCH_PERSON_VW SFA_CITIZSHIPVW SFA_PERUSACURVW SPECL_PROJECT SPECL_PROJ_LNG SSF_PERSON_VW TAX1042_BALANCE TAX1042_BAL_VW TAX_BALANCE TAX_BAL_VW TAX_CLASS_BAL TAX_CLASS_B_LNG TAX_DATA_NLD TRVL_CMPY_PAID UPG_BN_FSA_TMP UPG_ORGINST_TMP USER_PH_MO_VW USER_PH_PAGE_VW USER_PH_RZ_VW USER_PH_SYNC_VW USRTYP_DSPLY_VW USRTYP_FRML_VW VISA_PMT_DATA VOLUNTEER_ACT VOLUNTR_ACT_LNG WCS_PERSON_NM_I WCS_PERSON_NM_L WCS_PERS_NM_LV WCS_REQ_NM_LV WF_PERSON_NAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Default Value: NEW

2 BIRTHDATE Date(10) DATE Date of Birth

3 BIRTHPLACE Character(30) VARCHAR2(30) NOT NULL Birth Location

4 BIRTHCOUNTRY Character(3) VARCHAR2(3) NOT NULL Birth Country
Prompt Table: COUNTRY_TBL

5 BIRTHSTATE Character(6) VARCHAR2(6) NOT NULL Birth State
Prompt Table: BIRTHSTATE_VW

6 DT_OF_DEATH Date(10) DATE Date of Death

7 LAST_CHILD_UPDDTM DateTime(26) TIMESTAMP Used to indicate the last update to any data belonging to this logical object. For PER_ORG_ASGN - this means any update to its children in JOB_DATA that do not have their own date. For PERSON - this means any update to its children in PERSONAL_DATA that do not have their own date.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Default Value: NEW
2	BIRTHDATE	Date(10)	DATE	Date of Birth
3	BIRTHPLACE	Character(30)	VARCHAR2(30) NOT NULL	Birth Location
4	BIRTHCOUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Birth Country Prompt Table: COUNTRY_TBL
5	BIRTHSTATE	Character(6)	VARCHAR2(6) NOT NULL	Birth State Prompt Table: BIRTHSTATE_VW
6	DT_OF_DEATH	Date(10)	DATE	Date of Death
7	LAST_CHILD_UPDDTM	DateTime(26)	TIMESTAMP	Used to indicate the last update to any data belonging to this logical object. For PER_ORG_ASGN - this means any update to its children in JOB_DATA that do not have their own date. For PERSON - this means any update to its children in PERSONAL_DATA that do not have their own date.