Order

TRANS_CDE

TRANS_TYPE

TRANS_DESC

Notes

1

CRTSTU

CST

Create Student

Select records in SEVIS_STUDENT that do not have a CRTSTU transaction with a trans status of SUCCESS (6).

2

AUTHDB

UST

Authorize Drop Below Full

Select records that have an Auth DBF code.

3

COMPGM

UST

Complete Program

COMPLETE_PROG = Y where the history record is not COMPLETE_PROG = Y

4

EXTPGM

UST

Extend Program

(EXTEND_PROG = Y and history EXTEND_PROG = N) OR (PROG_START_DTE = history PROG_START_DTE and PROG_END_DTE > history PROG_END_DTE)

5

DFRATT

UST

Defer Attendance

(DFR_ATTENDANCE = Y and history DFR_ATTENDANCE = N) OR (PROG_START_DTE > history PROG_START_DTE and PROG_END_DTE > history PROG_END_DTE)

6

DISACT

UST

Disciplinary Action

CRIMINAL_CONVICTION = Y and history CRIMINAL_CONVICTION = N

7

TERMST

UST

Terminate Student

TERMINATION_REASON = <<Valid termination reason>> and history TERMINATION_REASON is null

8

SURE

UST

Student Registration

(PARENTHESISING > history PARENTHESISING and EXPRESSIONIST > PARENTHESISING

9

DETER

UST

Edit Personal

Select records where the history is different than the current data for each data element within this transaction.

10

EDT

UST

Edit Program Information

Select records where the history is different than the current data for each data element within this transaction.

11

EDT

UST

Edit Student Financial

Select records where the history is different than the current data for each data element within this transaction.

12

EDT

UST

Edit Dependent

Select records where the history is different than the current data for each data element within this transaction.

13

READS

UST

Reactivate Dependent

REACTIVATED = Y and history REACTIVATED = N

14

TEDS

UST

Terminate Dependent

TERMINATED = Y and history TERMINATE _DEPENDENT = N

15

ADDDPS

UST

Add Dependent

Select dependents where the Student has a create transaction and has not been sent to campus portal (JICS).

16

OFFCAM

UST

Off Campus Employment

EMPLOYMENT_TYPE <> history EMPLOYMENT_TYPE and no transaction of this type already sent.

17

CPTEMP

UST

CPT Employment

Employment START_DTE and END_DTE does not match a row in history and no transaction of this type already sent.

18

OPTEMP

UST

OPT Employment

Employment START_DTE and END_DTE does not match a row in history and no transaction of this type already sent.

19

RESFUL

UST

Resume Full Course

RESUME_FULL_CRS = Y and history RESUME_FULL_CRS = N

20

CPTUPD

UST

CPT Employment Update

Select records where the Employer information is different than the history record. Trans order 20 and 21 are used when data for the employer changes.

21

OPTUPD

UST

OPT Employment Update

Select records where the Employer information is different than the history record. Trans order 20 and 21 are used when data for the employer changes.

22

CRTEV

CEV

Create Exchange Visitor

Select records in SEVIS_EV that do not have a CRTEV transaction with a trans status of SUCCESS (6).

23

VALIEV

UEV

Validate Participant

IS_VALID = Y and history IS_VALID = N

24

EDTEVB

UEV

Edit EV Biograph

Select records where the history is different than the current data for each data element within this transaction.

25

ADDSOA

UEV

Add Site of Activity

Retrieves New Site Of Activity that have NOT been sent.

26

DELSOA

UEV

Delete Site of Activity

Retrieves Site Of Activity that have.

27

UPDSUB

UEV

Update Subject Field

SUBJECT_FIELD_CDE <> History SUBJECT_FIELD_CDE.

28

AMDPGM

UEV

Amend Program

(AMEND_PROG = Y and history AMEND_PROG = N) OR (PROG_START_DTE > history PROG_START_DTE and PROG_END_DTE > history PROG_END_DTE)

29

FINUPD

UEV

Financial Update

Select records where the history is different than the current data for each data element within this transaction.

30

EVEXTN

UEV

EV Extension

(EXTEND_PROG = Y and history EXTEND_PROG = N) OR (PROG_START_DTE = history PROG_START_DTE and PROG_END_DTE > history PROG_END_DTE)

31

EVMATR

UEV

EV Matriculation

EV_MATRICULATION ev_matriculation > if( isnull(h_ev_matriculation), '0', h_ev_matriculation)

32

CORRIN

UEV

Correct Infraction

INFRACTION_TYPE is not NULL and INFRACTION_TYPE <> History INFRACTION_TYPE

33

TERMEV

UEV

Terminate EV

TERMINATION_REASON is not NULL and TERMINATION_REASON <> History TERMINATION_REASON

34

ENDPGM

UEV

End Program

END_PROG_REASON is not NULL history END_PROG_REASON is NULL

35

EDTDPE

UEV

Edit Dependent

Select records where the history is different than the current data for each data element within this transaction.

36

TERDPE

UEV

Terminate Dependent

TERMINATE_DEPENDENT = Y and history TERMINATE _DEPENDENT = N

37

DEPESE

UEV

Dependent End Status

END_STATUS_REASON is not NULL and History END_STATUS_REASON is NULL

38

ADDDPE

UEV

Add Dependent

Select dependents where the EV has a create transaction and has not been sent to campus portal (JICS).