Create Person (Student ID) via PeopleCode ( Person Tables)


Sometime we need to create a person (Student ID) via PeopleCode for our custom process.


Component Interface is best way to comply with all PS logic but if you want to create person with SQL insert, here are the logic create person and related tables.

Get New Student ID
assign_cs_id(&EmplIDvariable)

Table Names
  • NAMES
  • PERS_NAME_TYPE
  • PERS_NID
  • ADDRESSES
  • ADDRESS_TYPE
  • EMAIL_ADDRESSES
  • PERSONAL_PHONE
  • PERSONAL_DATA
  • PERS_DATA_EFFDT
  • CITIZENSHIP
  • DIVERSITY
  • DISABILITY
  • PERSON_SA