J1 DIS Mapping

The table below describes which J1 tables are used as the source for certain Campus Portal (JICS) record types.

i_example.jpg

Campus Portal (JICS) TRM (Term) records are created using data from the YEAR_TERM_TABLE, YEAR_DEF, and TERM_DEF tables.

File Name

Campus Portal (JICS) Name

Type

Length

Req

J1 Table

J1 Column

Data type

Length

Notes

TRM

TRM

Term Code

Char

8

R

YEAR_DEF, TERM_DEF

YR_CDE + ' ' + TRM_CDE

Char

6

Example: 2000 10

TRM

Desc

Char

60

R

YEAR_DEF, TERM_DEF

DESC + ' ' + DESC

Char

60

 

TRM

Start Date

Date

10

R

YEAR_TERM_TABLE

TRM_BEGIN_DTE

DateTime

10

 

TRM

End Date

Date

10

R

YEAR_TERM_TABLE

TRM_END_DTE

DateTime

10

 

DPT

DPT

Dept Code

Char

6

R

CRS_COMP_[1-6]

CRS_COMP_[1-6]

Char

5

 

DPT

DESC

Char

60

R

CRS_COMP_[1-6]

CRS_COMP_[1-6]_DESC

Char

30

 

PRS

PRS

Host ID

Char

30

R

TW_WEB_SECURITY

ID_NUM

Numeric

9

 

PRS

Host Username

Char

30

R

TW_WEB_SECURITY

WEB_LOGIN

VarChar

513

 

PRS

Host Password

Char

30

R

TW_WEB_SECURITY

ACCESS_CDE

Char

16

Sent in plain text unless API_ENCRYPT_PASSWORDS = Y

This password is ignored in JICS versions 2021.1 and above.

PRS

First Name

Char

255

R

NameMaster

FIRST_NAME_TO_USE or FIRST_NAME

Char

30

If record has a row in the SALUTATION table where the SALUT_CDE = web_salutation_cde in the TW_UI_CONFIG, SALUTATION is used.

PRS

Middle Name

Char

255

O

NameMaster

MIDDLE_NAME_TO_USE or MIDDLE_NAME

Char

30

If record has a row in the SALUTATION table where the SALUT_CDE = web_salutation_cde in the TW_UI_CONFIG, SALUTATION is used.

PRS

Last Name

Char

255

R

NameMaster

LAST_NAME_TO_USE or LAST_NAME

Char

60

If record has a row in the SALUTATION table where the SALUT_CDE = web_salutation_cde in the TW_UI_CONFIG, SALUTATION is used.

PRS

Suffix

Char

255

O

NameMaster

SUFFIX_TO_USE or SUFFIX

Char

3

If record has a row in the SALUTATION table where the SALUT_CDE = web_salutation_cde in the TW_UI_CONFIG, SALUTATION is used.
Look up Desc in TABLE_DETAIL

PRS

E-Mail

Char

255

O

AlternateContactMethod

AlternateContact

Char

60

 

CST

CST

Host ID

Char

30

R

TW_GRP_MEMBERSHIP

ID_NUM

Numeric

9

 

CST

Dept Code

Char

6

O

Blank

Blank

N/A

0

 

CST

Status Code

Char

6

R

TW_GRP_MEMBERSHIP

GROUP_ID

Char

15

Do a lookup in the TW_GROUP.campus portal (JICS)_GROUP_ID column

CST

Degree Type

Char

6

O

Bland

Blank

Char

5

 

CST

Graduation Date

Date

10

O

Blank

Blank

N/A

10

 

CCD

CCD

Course Code

Char

20

R

CATALOG_MASTER

CRS_CDE

Char

30

 

CCD

Title

Char

80

R

CATALOG_MASTER

CRS_TITLE + CRS_TITLE_2

Char

70

 

CCD

Description

Char

1000

R

CATALOG_MASTER

CATALOG_TEXT

Text

2000000000

 

CCD

Dept Code

Char

6

R

CATALOG_MASTER

CRS_CDE

Char

5

Select from REG_CONFIG.DEPT_COMP to know which part of the CRS_CDE is the department

CRS

CRS

Term Code

Char

8

R

SECTION_MASTER

YR_CDE + ' ' + TRM_CDE

Char

7

Example: 2000 10

CRS

Course Code

Char

20

R

SECTION_MASTER

CRS_CDE

Char

30

Look up which course components are part of the Course Code where REG_CONFIG.CAT_USE_COMP_[1-6] = 'Y'

CRS

Section

Char

10

O

SECTION_MASTER

CRS_CDE

Char

30

These are the course components where REG_CONFIG.SECT_USE_COMP_[1-6] = 'Y' and REG_CONFIG.CAT_USER_COMP_[1-6] <> 'Y'

CRS

Title

Char

150

O

SECTION_MASTER

CRS_TITLE

Char

30

 

CRS

ERPCourse Key

Char

29

O

SECTION_MASTER

YR_CDE + ; + TRM_CDE + ; + CRS_CDE

Char

27

Example: 2000; 10; ART 100

SCH

SCH

Term Code

Char

8

R

SECTION_SCHEDULES

YR_CDE + ' ' + TRM_CDE

Char

6

Example: 2000 10

SCH

Course Code

Char

20

R

SECTION_SCHEDULES

CRS_CDE

Char

30

Look up which course components are part of the Course Code where REG_CONFIG.CAT_USE_COMP_[1-6] = 'Y'

SCH

Section

Char

10

O

SECTION_SCHEDULES

CRS_CDE

Char

30

These are the Course components where REG_CONFIG.SECT_USE_COMP_[1-6] = 'Y' and REG_CONFIG.CAT_USER_COMP_[1-6] <> 'Y'

SCH

Start Date

Date

10

O

SECTION_SCHEDULES

BEGIN_DTE

Datetime

10

 

SCH

End Date

Date

10

O

SECTION_SCHEDULES

END_DTE

Datetime

10

 

SCH

Days

Char

7

R

SECTION_SCHEDULES

[MONDAY-SUNDAY]_CDE

Char

7

Code converts day codes into codes for campus portal (JICS)/JCOM

SCH

Start Time

Char

10

R

SECTION_SCHEDULES

BEGIN_TIME

Datetime

10

  

SCH

End Time

Char

10

R

SECTION_SCHEDULES

END_TIME

Datetime

10

  

SCH

Location

Char

60

O

SECTION_SCHEDULES

LOC_CDE + ' ' + BLDG_CDE + ' ' + ROOM_CDE

Char

18

 

CRP

CRP

Term Code

Char

8

R

SECTION_MASTER

YR_CDE + ' ' + TRM_CDE

Char

6

Example: 2000 10

CRP

Course Code

Char

20

R

SECTION_MASTER

CRS_CDE

Char

30

Look up which course components are part of the Course Code where REG_CONFIG.CAT_USE_COMP_[1-6] = 'Y'

CRP

Section

Char

10

O

SECTION_MASTER

CRS_CDE

Char

30

These are the Course components where REG_CONFIG.SECT_USE_COMP_[1-6] = 'Y' and REG_CONFIG.CAT_USER_COMP_[1-6] <> 'Y'

CRP

Host ID

Char

30

R

STUDENT_CRS_HIST and FACULTY_LOAD_TABLE

ID_NUM and INSTRCTR_ID_NUM

Numeric

9

As of R10, CRP information for Faculty will be selected from FACULTY_LOAD_TABLE.

CRP

Status Code

Char

6

R

STU' or '1PR' based upon the select statement.

Calculated

Char

6

If from STUDENT_CRS_HIST, will be 'STU'; if from FACULTY_LOAD_TABLE, will be '1PR'

STU

STU

Host ID

Char

30

R

DEGREE_HISTORY

ID_NUM

Numeric

10

 

STU

LeaveOfAbsStart

Date

10

O

DEGREE_HISTORY

LAST_LEAVE_OF_ABSE

Datetime

10

  

STU

LeaveOfAbsEnd

Date

10

O

DEGREE_HISTORY

LAST_LEAVE_OF_ABSE_END_DTE

DateTime

10

  

STU

Probation

Char

2

O

STUDENT_MASTER

CUR_ACAD_PROBATION

Char

2

 

STU

Standing

Char

30

O

ACAD_STANDING_DEF

ACAD_STANDING_DESC

Char

30

 

STU

Major

Char

5

O

DEGREE_HISTORY

MAJOR_1

Char

5

 

STU

MajorDesc

Char

50

O

MAJOR_MINOR_DEF

MAJOR_MINOR_DESC

Char

50

 

STU

DivCode

Char

2

O

DEGREE_HISTORY

DIV_CDE

Char

2

 

STU

DivDesc

Char

30

O

DIVISION_DEF

DIV_DESC

Char

30