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