Trans Type

Action

Select

TRM

Add

Select Terms from YEAR_TERM_TABLE where YEAR_TERM_TABLE.SHOW_ON_WEB is B or L and YEAR_TERM_TABLE.TRM_END_DTE is >= current date and the term is not already in the TW_API_TRM table.

Update

Select Terms from YEAR_TERM_TABLE where YEAR_TERM_TABLE.SHOW_ON_WEB is B or L and YEAR_TERM_TABLE.TRM_END_DTE is >= current date and the term is already in the TW_API_TRM table where the YR_DESC, TRM_DESC, TRM_BEGIN_DTE or TRM_END_DTE are different.

Delete

Select Terms that are in the TW_API_TRM table that no longer meet the criteria of a TRM Add. However, a delete will not be sent if any child CRS records exist in the TW_API_CRS table.

DPT

Add

Select Departments from CRS_COMP_[1-6] that are not already in the TW_API_DPT table. To know which component is the department component, SELECT DEPT_COMP FROM REG_CONFIG.

Update

Select Departments from CRS_COMP_[1-6] where the department description <> department description in the TW_API_DPT table.

PRS

Add

Select all people in TW_WEB_SECURITY that are not in TW_API_PRS.

If Campus Portal (JICS), required columns are Login, First Name, Last Name. If required columns are missing, the record will not be selected.

Update

Select records that are in TW_WEB_SECURITY and TW_API_PRS where the login, password (which is ignored by JICS versions 2021.1 and above), first name, middle name, last name, e-mail, or suffix are different.

Delete

Select records that are in TW_API_PRS that are not in TW_WEB_SECURITY.

CST

Add

Select record must have a valid TW_API_PRS row.

If campus portal (JICS), select records with a corresponding campus portal (JICS)_GROUP_ID from TW_GROUP.campus portal (JICS)_GROUP_ID. Records in TW_GRP_MEMBERSHIP but not in TW_API_CST.

Delete

Select records in TW_API_CST that are not in TW_GRP_MEMBERSHIP where the groups match.

CCD

Add

Select records must have a valid DPT record. All CATALOG_MASTER records not in TW_API_CCD and where CATALOG_MASTER.ACTIVE_INACTIVE_STS is 'A'. CCD records must have a department already in TW_API_DPT.

Update

Select all CATALOG_MASTER records in TW_API_CCD where Title and Description are different.

CRS

Add

Select records from SECTION_MASTER where SECTION_MASTER.SHOW_ON_WEB is B or L and where the course is not in TW_API_CRS. If the Display of CrossListed courses configuration table setting is set to Display Child Course(s) on Parent Course List, select only the parent course(s) where X_LISTED_SECTION = 'P'. Otherwise, select both parent and child courses. Also, only select records that have related records in the TW_API_CCD and TW_API_TRM tables.

Update

Select records in SECTION_MASTER and TW_API_CRS where the course title is different.

Delete

Select terms that are in the TW_API_CRS table that no longer meet the criteria of a CRS Add. A delete will not be sent if the current date is greater than the end date.

SCH

Add

Select records must have a valid CRS record. Records in SECTION_SCHEDULES for the year/terms specified where YEAR_TERM_TABLE, SECTION_MASTER and SECTION_SCHEDULES SHOW_ON_WEB is B or L and where the record is not in TW_API_SCH.

Delete

Select schedules in the TW_API_SCH that no longer meet the criteria of a SCH Add.

CRP

Add

Select records must have a valid CRS record. All people in the TW_GRP_MEMBERSHIP table with a GROUP_ID of 'FACULTY' or 'STUDENT' are selected and All instructors on Faculty Load records and all students from Student Course History where record not in TW_API_CRP and SECTION_MASTER and YEAR_TERM_TABLE SHOW_ON_WEB is B or L.

Delete

Select records in the TW_API_CRP that no longer meet the criteria of a CRP Add. Do not select Withdraws.

Withdraw

Select records in TW_API_CRP that are in STUDENT_CRS_HIST where TRANS_STS = H and GRADE_CDE like %W%. Withdraws will only be sent with API_SEND_WITHDRAWS = 'Y'.

STU

Add

Select distinct ID_NUMs (and other data) from DEGREE_HISTORY where CUR_DEGREE = Y and YEAR_TERM_TABLE.TRM_END_DTE is >= current date and the ID_NUM is not already in the TW_API_STUDENT table.

Update

Select distinct ID_NUMs (and other data) from DEGREE_HISTORY where CUR_DEGREE = Y and YEAR_TERM_TABLE.TRM_END_DTE is >= current date, and the ID_NUM is already in the TW_API_STUDENT table.

Delete

Select records in the TW_API_STUDENT table that no longer meet the criteria of a STU Add.