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 ACADHISTORYVWLN ACAD_HISTORY ACAD_HISTORY_VW ACAD_PLAN_PR_VW ACAD_PLAN_TS_VW ACAD_PLAN_VW ACAD_PLAN_VW2 ACAD_PROG ACAD_PROG_IN_VW ACAD_PROG_I_VW ACAD_PROG_PLNVW ACAD_PROG_PR_VW ACAD_PROG_P_VW ACAD_PROG_RX_VW ACAD_PROG_R_VW ACAD_PROG_VW1 ACAD_PROG_VW2 ACAD_PROG_WHIF ACCOMPLISHMENTS ACCOMPLISHMT_VW ACCOMPLISH_LANG ADDRESSES ADDRESS_NPC_VW ADDRESS_TYPE ADDRESS_TYPE_LV ADDRESS_TYPE_V2 ADDRESS_TYPE_VW ADDR_CURR_VW ADDR_ORDER_VW ADM_APPLPROG_VW ADM_APPL_DEP ADM_COMMENTS ADM_COMNTS_LANG AP_ACI ASGN_CMP_EFFDT ASSGNMT_LNG ASSIGNMENT ASSIGNMENT_SRCH ASSIGNMENT_VW ATHL_PART_SPORT AUDIOMETRIC_LNG AUDIOMETRIC_TST AUDIO_TST_LANG AVCAREERVWLNG AVRELATEELNG AVRELATEPELNG AVRELPEVWLNG AV_CAREER_VW AV_EMAILADDR_VW AV_PERS_PHON_VW AV_PRSN_PDE_VW AV_PRSN_PHN_VW AV_RELATE_E AV_RELATE_PE AV_RELATION_VW AV_REL_PE_VW AV_URL_ADDR_VW AV_WORK_EXPR_VW 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 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 CC_ADDR_SEASNL CHECK_YTD CHECK_YTD_VW CITIZENSHIP CM_CATGRY_VW_LN CM_EE_COMP_TRN CM_EVALUATIONS CM_EVALUAT_LNG COMMUNICATION COMM_CATEGRY_VW COMPETENCIES_A COMPETENCY_DVLP COMPETENCY_STR COMP_PROP CO_PERSPHN_VW CRSE_SHARE_SET CRSE_SHRSET_LNG CRS_ACI CRS_ACI_MJR_C DAT_ACI DEDUCTION_BAL DED_ARREARS DED_ARR_SUM_VW DED_BAL_SUM_VW DED_BAL_VW DEPENDENT_BENEF DEPEND_BEN_LNG DEPEND_VW_LNG DEP_BEN DEP_BEN_EFF_LNG DEP_BEN_LNG DEP_BEN_VW1 DERIVED_STD_GRP DIRECT_DEPOSIT DISABILITY DISABILITY_V1 DISABILITY_V2 DISABILITY_V3 DISABILITY_V4 DISCIPLIN_ACTN DISCIP_ACT_LNG DRIVERS_LIC DRIVER_LIS_LANG DSADDR_EFF_VW DSNAMES_EFF_VW EMAIL_ADDRESSES EMAIL_ADDRES_VW EMAIL_PREF_VW EMERGENCY_CNTCT EMG_CNTCT_NM_VW EMPLOYMENT_LNG2 EMPLOYMENT_LNG3 EMPL_PHOTO ENRL_VER_REQST EOS_SPS EP_REVWR_ID_VW ERN_BAL_SUM_VW ERN_BAL_VW ETHNICITY_DTL EVAL_NAME_VW EXTERNAL_SYSKEY EXTRACUR_ACTVTY EXTRACUR_AC_LNG EYE_EXAM FA_FATERM_PARNT FED_TAX_DATA FERPA_CHG_AUDIT FERPA_OVERRIDE 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_PEREML_TAO FT_PERPHN_TAO FT_PERSON_PHONE FT_PER_EMAIL GARN_BALANCE GARN_SPEC GENLMATERIALLNG GENL_CMNT_LNG GENL_COMMENT GENL_EVALUATION GENL_MATERIALS GEN_MATERIAL_VW GMASS_ACI GNMATERIALVWLNG 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 GPIT_CCC_WA GPIT_CCC_WA_HST GPIT_RETRO_WA GPIT_RP_0001 GPIT_RP_0002 GPIT_RP_0003 GPIT_RP_0004 GPIT_RP_001_HST GPIT_RP_002_HST GPIT_RP_003_HST GPIT_RP_004_HST GPIT_RP_WA_KEYS GPIT_RTO_WA_HST GPIT_ULV_WA_HST GPIT_U_LEAVE_WA GPJP_EFILE_VW GPJP_EFIL_TAO 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 GPTH_DIS_ADD_VW GPTH_DIS_NM_VW GPTH_PERSON_NM GPTH_PER_ADDR 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_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 HCDL_FNAME_VW HCDL_LNAME_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_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 HD_360_EMAIL_WK HD_360_EMGCY_WK HD_360_PHNE_WK HEALTH_TEST HONOR_AWARD_CS HRS_ACT_PERS_I HRS_ACT_PRS_VW2 HRS_ACT_PRS_VW3 HRS_APP_INFO_I HRS_EE_EMAIL HRS_EE_PHONE HRS_EMPL_NM_I 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_PER_EMAIL_I HRS_PER_ORG_A_I HRS_PKG_NAME_I HRS_RECR_PERS_I HRS_REC_NM_I HR_ADDR_CHG_DAT HR_PERS_FR_VW HR_PERS_US_VW HR_SS_PERNM_SRC I20_FORM IMMUNIZATIONS INSTRCLASSVW2LN INSTRCLASSVW3LN INSTRCLASSVWLNG INSTR_ADVISOR INSTR_CLASS_VW INSTR_CLASS_VW1 INSTR_CLASS_VW2 INSTR_CLASS_VW3 INS_EARNS_BAL INS_EARN_CAN_VW INTL_SCHPGM ISIR_CITIZEN_VW ISIR_DRVLIC2_VW ISIR_DRV_LIC_VW ISIR_DUP_REQ ISIR_EMAIL_VW ISIR_REQUESTS ISIR_SIGNATURE JOB_DATE_VW JOB_PER_ORG_VW JPM_INTEREST JPM_INTEREST_VW NAMES NAMES_FERPA_VW NAMES_SS_TMP NAME_ALL_VW 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_HIR_CWR_VW ORIG_HIR_EMP_VW ORIG_HIR_PER_VW PAYROLL_DATA PAYROLL_DAT_LNG PA_GENL_COMMENT PD_ADDRESS_VW PERSONAL_DATA PERSONAL_DATTMP 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_CHECKLST PERSON_COMMENT PERSON_DTA_SRCH PERSON_EMAIL PERSON_FRA PERSON_INFO_BRA PERSON_NAME PERSON_PHONE PERSON_POI_VW PERS_ADDR_WF_SS PERS_APPL_INFO PERS_APPL_NAME 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_SA_VW PERS_DATA_USA PERS_DATA_US_VW PERS_EFFFRA_HIS PERS_EFF_FPSHIS PERS_HUKOU_CHN PERS_INST_REL PERS_NAME_PRF PERS_NAME_PRI PERS_NAME_TYPE PERS_NID PERS_NID_MSK_VW PERS_NID_PRM_VW PERS_NID_SA_VW PERS_NID_SF_VW PERS_NID_SF_VW2 PERS_NID_V PERS_NID_VW1 PERS_NID_VW2 PERS_PHONE_BUSN PERS_PHONE_CELL PERS_PHONE_FAX PERS_PHONE_HOME PERS_PHONE_PGR1 PERS_SMOKER PERS_SMOKER_VW PERS_SMOKER_VW2 PERS_SMOKER_VW3 PERS_SMOKER_VW4 PERS_STUDENT_VW PERS_WRKLIF_CHN PER_ASGN_CWR_VW PER_ASGN_EMP_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_POI_TYPE PHYSICAL_EXAM PHYS_EXAM_LANG PIN 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 RESIDENCY_SELF RESPIRATORY_EXM RESPIR_EXAM_LNG REVIEWER_NM_VW ROE SAA_NAME_PRF_VW SAA_NAME_PRI_VW SAA_PHOTO_VW SAD_ACT_CD SAD_CBAPCHK_AET SAD_CRS_CD SAD_EOS_CD SAD_GMS_CD SAD_GMT_CD SAD_GRE_CD SAD_PB_ADMDATVW SAD_PB_ADMNBRVW SAD_PB_ADMSCYVW SAD_PB_APGSCYVW SAD_SAT_CD SAD_SL_EMAIL_VW SAD_SL_EQN_VW1 SAD_SL_NAT_1_VW SAD_SL_NAT_2_VW SAD_SL_NAT_E_VW SAD_SL_OT_EM_VW SAD_SL_RESEF_VW SAD_SL_RESTP_VW SAD_SL_RES_C_VW SAD_SL_RES_E_VW SAD_SSS_CD SAD_STG_STDNCAR SAD_TAC_CD_VIC SAVINGS_403B_EE SAVINGS_MGT_EE SCC_ACCOM_LIC_2 SCC_ACCOM_LIC_I SCC_ACCOM_LNG_2 SCC_ACCOM_LNG_I SCC_ACCOM_MBR_2 SCC_ACCOM_MBR_I SCC_AUDIO_TSTLN SCC_AUDIO_TST_H SCC_CITIZSHIP_I SCC_CM_ADDRESS SCC_CM_EML_ADDR SCC_CM_NAMES SCC_CM_PERS_NID SCC_CM_PRSDTEFF SCC_CM_PRSDT_US SCC_COMM_360 SCC_CUR_ADDR_VW SCC_CUR_NAME_VW SCC_CUR_NM_VW2 SCC_DRVR_LIC_I SCC_EMERG_CNT_2 SCC_EMERG_CNT_H SCC_EMERG_CNT_I SCC_EYE_EXAM_H SCC_INS_ADDR_VW SCC_INS_NAME_VW SCC_LANGUAGES_H SCC_LIC_CERT_H SCC_MEMBERSHP_H SCC_NM_TYPE2PVW SCC_NM_TYPE_PVW SCC_PDE_CAN_H SCC_PERNM_NP_VW SCC_PERS_CHKLST SCC_PERS_NID_VW SCC_PERS_PHONE SCC_PER_ADDR_I SCC_PER_DIR_VW SCC_PER_EMAIL_I SCC_PER_NAME_I SCC_PER_NAME_I2 SCC_PER_NID_I SCC_PER_PDE_I SCC_PER_PHN_WRK SCC_PER_PHONE_I SCC_PHYS_EXAM_H SCC_PREF_EMAIL SCC_PREF_PHN_VW SCC_PRFONLYNMVW SCC_PRFPRIMNMVW SCC_PRIONLYNMVW SCC_PRI_ADDR_VW SCC_PRI_NAME_VW SCC_RESP_EXAM_H SCC_SFP_LOA_VW SCC_SFP_PRPL_VW SCC_SFP_RLOA_VW SCC_SL_ESTB_NLD SCC_STG_VP_NLD SCC_VISAPMT_NLD SCC_VISA_PMT_I SCC_VOC_ACPR_VW SEL_STDNOR2_VW SEL_STDNORE2_VW SEL_STDNORES_VW SEV_I20_INST_VW SFA_ASG_ACPR_VW SFA_CITIZSHIPVW SFA_LN_STU_CIT SFA_PDE_CURR SFA_PERUSACURVW SFA_SAP_STDNT SFA_SAP_STDNT2 SFA_SAP_STDNT3 SFA_SAP_STDNT4 SF_ISET_DEP_VW SPECL_PROJECT SPECL_PROJ_LNG SRVC_IND_DATA SRVC_IND_FA_VW SSF_BANKACC_NLD SSF_COR_BANKACC SSF_COR_BNK_NLD SSF_COR_BNK_VW SSF_IHC_STDPAR SSF_PERSON_VW SSF_STU_BNK_NLD SSF_STU_BNK_VW SSRFINEXAMLNG SSR_ACADPLAN_VW SSR_ACADPLN2VLN SSR_ACADPLN2_VW SSR_ACADPLN3_VW SSR_ACDPLN3VWLN SSR_ACPLN_CIPVW SSR_APTSYT_IDVW SSR_CORRSPN_NLD SSR_EMPPHOTO_VW SSR_EMP_NAT_NLD SSR_ENRLVER_VW SSR_EV_RQ_VW SSR_FCINSTRENR1 SSR_FC_INSTRENR SSR_FC_PHOTO_VW SSR_FIN_EXAM_VW SSR_GR_NAME_LN SSR_HE_ACPLN_VW SSR_INST_ADV_VW SSR_NAMES_NLD SSR_PERSON_NM_I SSR_PRFONLYNMVW SSR_PRIONLYNMVW SSR_PROGPLAN_VW SSR_PROG_CAF_LN SSR_SCHOLAR_NLD SSR_STAD_PRPL SSR_STAD_PRPL2 SSR_STAD_PRPL3 SSR_STDNT_CIPLN SSR_STD_EDU_NLD SSR_STENR_GRDVW SSR_STUDENT_NLD SS_STDNT_CAR_VW STDNTCAREERV2LN STDNTCAREERVWLN STDNT_CAREER STDNT_CAREER_V2 STDNT_CAREER_VW STDNT_ENRL_VW STDNT_GRPS STDNT_GRP_TAO STDNT_TEST STDNT_WAIV_FORM TAX1042_BALANCE TAX1042_BAL_VW TAX_BALANCE TAX_BAL_VW TAX_CLASS_BAL TAX_CLASS_B_LNG TAX_DATA_NLD TRACKING_GRPS TRVL_CMPY_PAID UPG_BN_FSA_TMP UPG_ORGINST_TMP URL_ADDRESSES VISA_PMT_DATA VOLUNTEER_ACT VOLUNTR_ACT_LNG 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.