PROCESS_INSTANCEHARD=Delete Record
SOFT=Inactivate Record
FULL=Full Synchronization
INCR=Incremental Synchronization
ALL=All Detail
USAG=Based on Usage
N=Address Usage
Y=Preferred Email
SAE_LDAPSNAPAET(SQL Table) |
Index Back |
|---|---|
LDAP Snapshot State RecordLDAP Snapshot State Record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | BIRTHDATE | Date(10) | DATE | Date of Birth |
| 3 | BIRTHPLACE | Character(30) | VARCHAR2(30) NOT NULL | Birth Location |
| 4 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 5 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 6 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 7 | SAE_ADDRESS_USAGE | Character(10) | VARCHAR2(10) NOT NULL | IMS Address |
| 8 | SAE_DELETE_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Delete Type: either HARD or SOFT. If the delete type is HARD, then the entry is actually to be deleted. If it is SOFT, then a deleted status indicator is to be set.
HARD=Delete Record SOFT=Inactivate Record |
| 9 | SAE_DIRECTORY_ID | Character(50) | VARCHAR2(50) NOT NULL | Directory ID for LDAP |
| 10 | SAE_TARGET_ID | Character(50) | VARCHAR2(50) NOT NULL | SAIP Target ID |
| 11 | SAE_EMAIL_USAGE | Character(10) | VARCHAR2(10) NOT NULL | Email Address Usage |
| 12 | SAE_FORMNAME_USAGE | Character(10) | VARCHAR2(10) NOT NULL | IMS Form Name |
| 13 | SAE_GET_ENT_ROLE | Character(1) | VARCHAR2(1) NOT NULL | Selection option to choose whether to extract enterprise role information. |
| 14 | SAE_IMS_SOURCE | Character(50) | VARCHAR2(50) NOT NULL | IMS Source |
| 15 | SAE_LASTFULLSYNCID | Number(5,0) | INTEGER NOT NULL | Last Full Sync ID number. This is used to determine whether an entry had been updated during the last full sync. If that entry does not have the latest full sync id number, then it should be deleted. |
| 16 | SAE_LDAP_PATH_GRP | Character(250) | VARCHAR2(250) NOT NULL | SAIP LDAP Binding path to Group |
| 17 | SAE_LDAP_PATH_MEM | Character(250) | VARCHAR2(250) NOT NULL | SAIP LDAP Binding path to membership |
| 18 | SAE_LDAP_PATH_OFFR | Character(250) | VARCHAR2(250) NOT NULL | SAIP LDAP Binding path to course offering |
| 19 | SAE_LDAP_PATH_PER | Character(250) | VARCHAR2(250) NOT NULL | SAIP LDAP Binding path to Person |
| 20 | SAE_LDAP_PATH_PERD | Character(250) | VARCHAR2(250) NOT NULL | SAIP LDAP Binding Path to Person Details |
| 21 | SAE_LDAP_PATH_SCAS | Character(250) | VARCHAR2(250) NOT NULL | SAIP LDAP Binding path to course section association |
| 22 | SAE_LDAP_PATH_SECT | Character(250) | VARCHAR2(250) NOT NULL | SAIP LDAP Binding path to course section |
| 23 | SAE_LDAP_PATH_TPLT | Character(250) | VARCHAR2(250) NOT NULL | SAIP LDAP Binding path to course template |
| 24 | SAE_LDAP_SYNC_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Student Administration Integration Platform LDAP synchronization request type
FULL=Full Synchronization INCR=Incremental Synchronization |
| 25 | SAE_LDAPSYNCCRSOFR | Character(1) | VARCHAR2(1) NOT NULL | Synchronize Course Offering Yes No Indicator |
| 26 | SAE_LDAPSYNCCRSSEC | Character(1) | VARCHAR2(1) NOT NULL | Synchronize Course Section Yes No Indicator |
| 27 | SAE_LDAPSYNCCRSTMP | Character(1) | VARCHAR2(1) NOT NULL | Synchronize Course Template Yes No Indicator |
| 28 | SAE_LDAPSYNCCSECAS | Character(1) | VARCHAR2(1) NOT NULL | Synchronize Course Section Association Yes No Indicator |
| 29 | SAE_LDAPSYNCGROUP | Character(1) | VARCHAR2(1) NOT NULL | Synchronize Group Yes No Indicator |
| 30 | SAE_LDAPSYNCMEMBER | Character(1) | VARCHAR2(1) NOT NULL | Synchronize Membership Yes No Indicator |
| 31 | SAE_LDAPSYNCPERSON | Character(1) | VARCHAR2(1) NOT NULL | Synchronize Person Yes No Indicator |
| 32 | SAE_LDAPSYNCUNIT | Character(1) | VARCHAR2(1) NOT NULL | Synchronize Unit |
| 33 | SAE_LDIF_FILE_PATH | Character(254) | VARCHAR2(254) NOT NULL | File name and path to where the LDIF file will be written. |
| 34 | SAE_LSTSYNCCOF_DTM | DateTime(26) | TIMESTAMP | SAIP last synchronization course offering date time. This is the date time stamp indicating when course offering entries were last synchronized. |
| 35 | SAE_LSTSYNCCSA_DTM | DateTime(26) | TIMESTAMP | SAIP last synchronization course section associations date time. This is the date time stamp indicating when course section association entries were last synchronized. |
| 36 | SAE_LSTSYNCCSC_DTM | DateTime(26) | TIMESTAMP | SAIP last synchronization course sections date time. This is the date time stamp indicating when course section entries were last synchronized. |
| 37 | SAE_LSTSYNCCTM_DTM | DateTime(26) | TIMESTAMP | SAIP last synchronization course template date time. This is the date time stamp indicating when course template entries were last synchronized. |
| 38 | SAE_LSTSYNCGRP_DTM | DateTime(26) | TIMESTAMP | SAIP last synchronization group date time. This is the date time stamp indicating when group entries were last synchronized. |
| 39 | SAE_LSTSYNCMEM_DTM | DateTime(26) | TIMESTAMP | SAIP last synchronization membership date time. This is the date time stamp indicating when membership entries were last synchronized. |
| 40 | SAE_LSTSYNCPER_DTM | DateTime(26) | TIMESTAMP | SAIP last synchronization person date time. This is the date time stamp indicating when person entries were last synchronized. |
| 41 | SAE_NAME_USAGE | Character(10) | VARCHAR2(10) NOT NULL | IMS Name |
| 42 | SAE_PERSON_GET_OPT | Character(4) | VARCHAR2(4) NOT NULL |
Person extract option. See translate values for list of valid options.
ALL=All Detail USAG=Based on Usage |
| 43 | SAE_PHONE_USAGE | Character(10) | VARCHAR2(10) NOT NULL | IMS Phone |
| 44 | SAE_PREF_EMAILFLAG | Character(1) | VARCHAR2(1) NOT NULL |
Preferred Email
N=Address Usage Y=Preferred Email |
| 45 | SAE_SMS_USAGE | Character(10) | VARCHAR2(10) NOT NULL | IMS SMS |
| 46 | SAE_WEB_USAGE | Character(10) | VARCHAR2(10) NOT NULL | IMS Web |