campus solutions subject area dictionary · presentation table presentation column presentation...

47
Campus Solutions Subject Area Dictionary CSW - Student Records - Term Enrollment Presentation Table Presentation Column Presentation Description Logical Table Source ETL Logic and Logical Expression from Business Layer (if applicable) Physical Table Physical Column PeopleSoft Table Academic Level End Term End Term Academic Level Desc The academic level long description. D_ACAD_LVL_End_Term PS_D_ACAD_LVL ACAD_LVL_LD PSXLATITEM Current Indicator The current row indicator. D_ACAD_LVL_End_Term PS_D_ACAD_LVL CURRENT_IND End Term Academic Level The academic level short description. D_ACAD_LVL_End_Term PS_D_ACAD_LVL ACAD_LVL_SD PSXLATITEM End Term Academic Level Code The academic level code. D_ACAD_LVL_End_Term PS_D_ACAD_LVL ACAD_LVL_CD PSXLATITEM Source System Id The source system from where the data originated. D_ACAD_LVL_End_Term PS_D_ACAD_LVL SRC_SYS_ID PSXLATITEM Academic Level Projected Projected Academic Level Code The academic level code. D_ACAD_LVL_Projected PS_D_ACAD_LVL ACAD_LVL_CD PSXLATITEM Current Indicator The current row indicator. D_ACAD_LVL_Projected PS_D_ACAD_LVL CURRENT_IND Source System Id The source system from where the data originated. D_ACAD_LVL_Projected PS_D_ACAD_LVL SRC_SYS_ID PSXLATITEM Projected Academic Level The academic level short description. D_ACAD_LVL_Projected PS_D_ACAD_LVL ACAD_LVL_SD PSXLATITEM Projected Academic Level Desc The academic level long description. D_ACAD_LVL_Projected PS_D_ACAD_LVL ACAD_LVL_LD PSXLATITEM Academic Level Start Term Monday, May 13, 2013 Page 1 of 47

Upload: others

Post on 03-Aug-2020

4 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: Campus Solutions Subject Area Dictionary · Presentation Table Presentation Column Presentation Description Logical Table Source ETL Logic and Logical Expression from Business Layer

Campus Solutions Subject Area Dictionary

CSW - Student Records - Term Enrollment

Presentation Table

Presentation Column Presentation Description Logical Table Source

ETL Logic and Logical Expression from Business Layer (if applicable)

Physical Table Physical Column PeopleSoft Table

Academic Level End Term

End Term Academic Level Desc

The academic level long description.

D_ACAD_LVL_End_Term PS_D_ACAD_LVL ACAD_LVL_LD PSXLATITEM

Current Indicator The current row indicator. D_ACAD_LVL_End_Term PS_D_ACAD_LVL CURRENT_IND

End Term Academic Level

The academic level short description.

D_ACAD_LVL_End_Term PS_D_ACAD_LVL ACAD_LVL_SD PSXLATITEM

End Term Academic Level Code

The academic level code. D_ACAD_LVL_End_Term PS_D_ACAD_LVL ACAD_LVL_CD PSXLATITEM

Source System Id The source system from where the data originated.

D_ACAD_LVL_End_Term PS_D_ACAD_LVL SRC_SYS_ID PSXLATITEM

Academic Level Projected

Projected Academic Level Code

The academic level code. D_ACAD_LVL_Projected PS_D_ACAD_LVL ACAD_LVL_CD PSXLATITEM

Current Indicator The current row indicator. D_ACAD_LVL_Projected PS_D_ACAD_LVL CURRENT_IND

Source System Id The source system from where the data originated.

D_ACAD_LVL_Projected PS_D_ACAD_LVL SRC_SYS_ID PSXLATITEM

Projected Academic Level

The academic level short description.

D_ACAD_LVL_Projected PS_D_ACAD_LVL ACAD_LVL_SD PSXLATITEM

Projected Academic Level Desc

The academic level long description.

D_ACAD_LVL_Projected PS_D_ACAD_LVL ACAD_LVL_LD PSXLATITEM

Academic Level Start Term

Monday, May 13, 2013 Page 1 of 47

Page 2: Campus Solutions Subject Area Dictionary · Presentation Table Presentation Column Presentation Description Logical Table Source ETL Logic and Logical Expression from Business Layer

CSW - Student Records - Term Enrollment

Presentation Table

Presentation Column Presentation Description Logical Table Source

ETL Logic and Logical Expression from Business Layer (if applicable)

Physical Table Physical Column PeopleSoft Table

Academic Level Start Term

Start Term Academic Level Code

The academic level code. D_ACAD_LVL_Start_Term PS_D_ACAD_LVL ACAD_LVL_CD PSXLATITEM

Start Term Academic Level

The academic level short description.

D_ACAD_LVL_Start_Term PS_D_ACAD_LVL ACAD_LVL_SD PSXLATITEM

Start Term Academic Level Desc

The academic level long description.

D_ACAD_LVL_Start_Term PS_D_ACAD_LVL ACAD_LVL_LD PSXLATITEM

Current Indicator The current row indicator. D_ACAD_LVL_Start_Term PS_D_ACAD_LVL CURRENT_IND

Source System Id The source system from where the data originated.

D_ACAD_LVL_Start_Term PS_D_ACAD_LVL SRC_SYS_ID PSXLATITEM

Academic Load

Academic Load This is the short description of the academic load of a student.

D_ACAD_LOAD PS_D_ACAD_LOAD ACAD_LOAD_SD PSXLATITEM

Current Indicator The current row indicator. D_ACAD_LOAD PS_D_ACAD_LOAD CURRENT_IND

Academic Load Desc This is the long description of the academic load of a student.

D_ACAD_LOAD PS_D_ACAD_LOAD ACAD_LOAD_LD PSXLATITEM

Academic Load Code This is the code that identifies the academic load of a student.

D_ACAD_LOAD PS_D_ACAD_LOAD ACAD_LOAD_CD PSXLATITEM

Source System Id The source system from where the data originated.

D_ACAD_LOAD PS_D_ACAD_LOAD SRC_SYS_ID PSXLATITEM

Approved Indicator This is a flag that indicates whether the academic load is approved or not.

D_ACAD_LOAD PS_D_ACAD_LOAD APPRVD_IND PSXLATITEM

Academic Organization

Monday, May 13, 2013 Page 2 of 47

Page 3: Campus Solutions Subject Area Dictionary · Presentation Table Presentation Column Presentation Description Logical Table Source ETL Logic and Logical Expression from Business Layer

CSW - Student Records - Term Enrollment

Presentation Table

Presentation Column Presentation Description Logical Table Source

ETL Logic and Logical Expression from Business Layer (if applicable)

Physical Table Physical Column PeopleSoft Table

Academic Organization

Academic Organization Level 28 Id

This is the identifier for the academic organization hierarchy level 28.

V_ACAD_ORG PS_V_ACAD_ORG L28_ID PS_ACAD_ORG_TBL, PS_CAMPUS_TBL, Tree

Academic Organization Level 31 Desc

This is the description for the academic organization hierarchy level 31.

V_ACAD_ORG PS_V_ACAD_ORG L31_DESC PS_ACAD_ORG_TBL, PS_CAMPUS_TBL, Tree

Academic Organization Level 2 Id

This is the identifier for the academic organization hierarchy level 2.

V_ACAD_ORG PS_V_ACAD_ORG L2_ID PS_ACAD_ORG_TBL, PS_CAMPUS_TBL, Tree

Academic Organization Level 2 Desc

This is the description for the academic organization hierarchy level 2.

V_ACAD_ORG PS_V_ACAD_ORG L2_DESC PS_ACAD_ORG_TBL, PS_CAMPUS_TBL, Tree

Academic Organization Level 3 Id

This is the identifier for the academic organization hierarchy level 3.

V_ACAD_ORG PS_V_ACAD_ORG L3_ID PS_ACAD_ORG_TBL, PS_CAMPUS_TBL, Tree

Academic Organization Level 3 Desc

This is the description for the academic organization hierarchy level 3.

V_ACAD_ORG PS_V_ACAD_ORG L3_DESC PS_ACAD_ORG_TBL, PS_CAMPUS_TBL, Tree

Academic Organization Level 4 Id

This is the identifier for the academic organization hierarchy level 4.

V_ACAD_ORG PS_V_ACAD_ORG L4_ID PS_ACAD_ORG_TBL, PS_CAMPUS_TBL, Tree

Current Indicator The current row indicator. D_ACAD_ORG PS_D_ACAD_ORG CURRENT_IND

Academic Organization Level 31 Id

This is the identifier for the academic organization hierarchy level 31.

V_ACAD_ORG PS_V_ACAD_ORG L31_ID PS_ACAD_ORG_TBL, PS_CAMPUS_TBL, Tree

Academic Organization Level 30 Desc

This is the description for the academic organization hierarchy level 30.

V_ACAD_ORG PS_V_ACAD_ORG L30_DESC PS_ACAD_ORG_TBL, PS_CAMPUS_TBL, Tree

Monday, May 13, 2013 Page 3 of 47

Page 4: Campus Solutions Subject Area Dictionary · Presentation Table Presentation Column Presentation Description Logical Table Source ETL Logic and Logical Expression from Business Layer

CSW - Student Records - Term Enrollment

Presentation Table

Presentation Column Presentation Description Logical Table Source

ETL Logic and Logical Expression from Business Layer (if applicable)

Physical Table Physical Column PeopleSoft Table

Academic Organization

Academic Organization Level 30 Id

This is the identifier for the academic organization hierarchy level 30.

V_ACAD_ORG PS_V_ACAD_ORG L30_ID PS_ACAD_ORG_TBL, PS_CAMPUS_TBL, Tree

Academic Organization Level 29 Desc

This is the description for the academic organization hierarchy level 29.

V_ACAD_ORG PS_V_ACAD_ORG L29_DESC PS_ACAD_ORG_TBL, PS_CAMPUS_TBL, Tree

Academic Organization Level 1 Desc

This is the description for the academic organization hierarchy level 1.

V_ACAD_ORG PS_V_ACAD_ORG L1_DESC PS_ACAD_ORG_TBL, PS_CAMPUS_TBL, Tree

Academic Organization Level 28 Desc

This is the description for the academic organization hierarchy level 28.

V_ACAD_ORG PS_V_ACAD_ORG L28_DESC PS_ACAD_ORG_TBL, PS_CAMPUS_TBL, Tree

Institution Code This is the code that identifies an academic institution.

D_ACAD_ORG PS_D_ACAD_ORG INSTITUTION_CD PS_ACAD_ORG_TBL

Academic Organization Level 29 Id

This is the identifier for the academic organization hierarchy level 29.

V_ACAD_ORG PS_V_ACAD_ORG L29_ID PS_ACAD_ORG_TBL, PS_CAMPUS_TBL, Tree

Campus Desc This is the long description that identifies a campus.

D_ACAD_ORG PS_D_ACAD_ORG CAMPUS_LD PS_ACAD_ORG_TBL

Source System Id The source system from where the data originated.

D_ACAD_ORG PS_D_ACAD_ORG SRC_SYS_ID PS_ACAD_ORG_TBL

Academic Organization Code

This is the code that identifies an academic organization.

D_ACAD_ORG PS_D_ACAD_ORG ACAD_ORG_CD PS_ACAD_ORG_TBL

Academic Organization

This is the short description for the academic organization.

D_ACAD_ORG PS_D_ACAD_ORG ACAD_ORG_SD PS_ACAD_ORG_TBL

Academic Organization Desc

This is the long description for the academic organization.

D_ACAD_ORG PS_D_ACAD_ORG ACAD_ORG_LD PS_ACAD_ORG_TBL

Monday, May 13, 2013 Page 4 of 47

Page 5: Campus Solutions Subject Area Dictionary · Presentation Table Presentation Column Presentation Description Logical Table Source ETL Logic and Logical Expression from Business Layer

CSW - Student Records - Term Enrollment

Presentation Table

Presentation Column Presentation Description Logical Table Source

ETL Logic and Logical Expression from Business Layer (if applicable)

Physical Table Physical Column PeopleSoft Table

Academic Organization

Campus Code This is the code that identifies the campus.

D_ACAD_ORG PS_D_ACAD_ORG CAMPUS_CD PS_ACAD_ORG_TBL

Institution Desc This is the long description that identifies an academic institution.

D_ACAD_ORG PS_D_ACAD_ORG INSTITUTION_LD PS_ACAD_ORG_TBL

Campus This is the short description that identifies a campus.

D_ACAD_ORG PS_D_ACAD_ORG CAMPUS_SD PS_ACAD_ORG_TBL

Academic Organization Level 1 Id

This is the identifier for the academic organization hierarchy level 1.

V_ACAD_ORG PS_V_ACAD_ORG L1_ID PS_ACAD_ORG_TBL, PS_CAMPUS_TBL, Tree

Academic Organization Level 26 Desc

This is the description for the academic organization hierarchy level 26.

V_ACAD_ORG PS_V_ACAD_ORG L26_DESC PS_ACAD_ORG_TBL, PS_CAMPUS_TBL, Tree

Institution This is the short description that identifies an academic institution.

D_ACAD_ORG PS_D_ACAD_ORG INSTITUTION_SD PS_ACAD_ORG_TBL

Academic Organization Level 5 Id

This is the identifier for the academic organization hierarchy level 5.

V_ACAD_ORG PS_V_ACAD_ORG L5_ID PS_ACAD_ORG_TBL, PS_CAMPUS_TBL, Tree

Academic Organization Tree Name

This is the tree name for the academic organization.

V_ACAD_ORG PS_V_ACAD_ORG TREE_NAME PS_ACAD_ORG_TBL, PS_CAMPUS_TBL, Tree

Academic Organization Detail Id

This is the detail identification code for the academic organization tree.

V_ACAD_ORG PS_V_ACAD_ORG DTL_ID PS_ACAD_ORG_TBL, PS_CAMPUS_TBL, Tree

Academic Organization Detail Desc

This is the long description for the academic organization tree detail.

V_ACAD_ORG PS_V_ACAD_ORG DTL_DESC PS_ACAD_ORG_TBL, PS_CAMPUS_TBL, Tree

Monday, May 13, 2013 Page 5 of 47

Page 6: Campus Solutions Subject Area Dictionary · Presentation Table Presentation Column Presentation Description Logical Table Source ETL Logic and Logical Expression from Business Layer

CSW - Student Records - Term Enrollment

Presentation Table

Presentation Column Presentation Description Logical Table Source

ETL Logic and Logical Expression from Business Layer (if applicable)

Physical Table Physical Column PeopleSoft Table

Academic Organization

Academic Organization Level 4 Desc

This is the description for the academic organization hierarchy level 4.

V_ACAD_ORG PS_V_ACAD_ORG L4_DESC PS_ACAD_ORG_TBL, PS_CAMPUS_TBL, Tree

Academic Organization Level 10 Id

This is the identifier for the academic organization hierarchy level 10.

V_ACAD_ORG PS_V_ACAD_ORG L10_ID PS_ACAD_ORG_TBL, PS_CAMPUS_TBL, Tree

Academic Organization Level 15 Id

This is the identifier for the academic organization hierarchy level 15.

V_ACAD_ORG PS_V_ACAD_ORG L15_ID PS_ACAD_ORG_TBL, PS_CAMPUS_TBL, Tree

Academic Organization Level 14 Desc

This is the description for the academic organization hierarchy level 14.

V_ACAD_ORG PS_V_ACAD_ORG L14_DESC PS_ACAD_ORG_TBL, PS_CAMPUS_TBL, Tree

Academic Organization Level 14 Id

This is the identifier for the academic organization hierarchy level 14.

V_ACAD_ORG PS_V_ACAD_ORG L14_ID PS_ACAD_ORG_TBL, PS_CAMPUS_TBL, Tree

Academic Organization Level 13 Desc

This is the description for the academic organization hierarchy level 13.

V_ACAD_ORG PS_V_ACAD_ORG L13_DESC PS_ACAD_ORG_TBL, PS_CAMPUS_TBL, Tree

Academic Organization Level 13 Id

This is the identifier for the academic organization hierarchy level 13.

V_ACAD_ORG PS_V_ACAD_ORG L13_ID PS_ACAD_ORG_TBL, PS_CAMPUS_TBL, Tree

Academic Organization Level 12 Desc

This is the description for the academic organization hierarchy level 12.

V_ACAD_ORG PS_V_ACAD_ORG L12_DESC PS_ACAD_ORG_TBL, PS_CAMPUS_TBL, Tree

Academic Organization Level 12 Id

This is the identifier for the academic organization hierarchy level 12.

V_ACAD_ORG PS_V_ACAD_ORG L12_ID PS_ACAD_ORG_TBL, PS_CAMPUS_TBL, Tree

Monday, May 13, 2013 Page 6 of 47

Page 7: Campus Solutions Subject Area Dictionary · Presentation Table Presentation Column Presentation Description Logical Table Source ETL Logic and Logical Expression from Business Layer

CSW - Student Records - Term Enrollment

Presentation Table

Presentation Column Presentation Description Logical Table Source

ETL Logic and Logical Expression from Business Layer (if applicable)

Physical Table Physical Column PeopleSoft Table

Academic Organization

Academic Organization Level 11 Desc

This is the description for the academic organization hierarchy level 11.

V_ACAD_ORG PS_V_ACAD_ORG L11_DESC PS_ACAD_ORG_TBL, PS_CAMPUS_TBL, Tree

Academic Organization Level 27 Desc

This is the description for the academic organization hierarchy level 27.

V_ACAD_ORG PS_V_ACAD_ORG L27_DESC PS_ACAD_ORG_TBL, PS_CAMPUS_TBL, Tree

Academic Organization Level 10 Desc

This is the description for the academic organization hierarchy level 10.

V_ACAD_ORG PS_V_ACAD_ORG L10_DESC PS_ACAD_ORG_TBL, PS_CAMPUS_TBL, Tree

Academic Organization Level 16 Desc

This is the description for the academic organization hierarchy level 16.

V_ACAD_ORG PS_V_ACAD_ORG L16_DESC PS_ACAD_ORG_TBL, PS_CAMPUS_TBL, Tree

Academic Organization Level 9 Desc

This is the description for the academic organization hierarchy level 9.

V_ACAD_ORG PS_V_ACAD_ORG L9_DESC PS_ACAD_ORG_TBL, PS_CAMPUS_TBL, Tree

Academic Organization Level 9 Id

This is the identifier for the academic organization hierarchy level 9.

V_ACAD_ORG PS_V_ACAD_ORG L9_ID PS_ACAD_ORG_TBL, PS_CAMPUS_TBL, Tree

Academic Organization Level 8 Desc

This is the description for the academic organization hierarchy level 8.

V_ACAD_ORG PS_V_ACAD_ORG L8_DESC PS_ACAD_ORG_TBL, PS_CAMPUS_TBL, Tree

Academic Organization Level 8 Id

This is the identifier for the academic organization hierarchy level 8.

V_ACAD_ORG PS_V_ACAD_ORG L8_ID PS_ACAD_ORG_TBL, PS_CAMPUS_TBL, Tree

Academic Organization Level 7 Desc

This is the description for the academic organization hierarchy level 7.

V_ACAD_ORG PS_V_ACAD_ORG L7_DESC PS_ACAD_ORG_TBL, PS_CAMPUS_TBL, Tree

Monday, May 13, 2013 Page 7 of 47

Page 8: Campus Solutions Subject Area Dictionary · Presentation Table Presentation Column Presentation Description Logical Table Source ETL Logic and Logical Expression from Business Layer

CSW - Student Records - Term Enrollment

Presentation Table

Presentation Column Presentation Description Logical Table Source

ETL Logic and Logical Expression from Business Layer (if applicable)

Physical Table Physical Column PeopleSoft Table

Academic Organization

Academic Organization Level 7 Id

This is the identifier for the academic organization hierarchy level 7.

V_ACAD_ORG PS_V_ACAD_ORG L7_ID PS_ACAD_ORG_TBL, PS_CAMPUS_TBL, Tree

Academic Organization Level 6 Desc

This is the description for the academic organization hierarchy level 6.

V_ACAD_ORG PS_V_ACAD_ORG L6_DESC PS_ACAD_ORG_TBL, PS_CAMPUS_TBL, Tree

Academic Organization Level 6 Id

This is the identifier for the academic organization hierarchy level 6.

V_ACAD_ORG PS_V_ACAD_ORG L6_ID PS_ACAD_ORG_TBL, PS_CAMPUS_TBL, Tree

Academic Organization Level 5 Desc

This is the description for the academic organization hierarchy level 5.

V_ACAD_ORG PS_V_ACAD_ORG L5_DESC PS_ACAD_ORG_TBL, PS_CAMPUS_TBL, Tree

Academic Organization Level 11 Id

This is the identifier for the academic organization hierarchy level 11.

V_ACAD_ORG PS_V_ACAD_ORG L11_ID PS_ACAD_ORG_TBL, PS_CAMPUS_TBL, Tree

Academic Organization Level 21 Id

This is the identifier for the academic organization hierarchy level 21.

V_ACAD_ORG PS_V_ACAD_ORG L21_ID PS_ACAD_ORG_TBL, PS_CAMPUS_TBL, Tree

Academic Organization Level 26 Id

This is the identifier for the academic organization hierarchy level 26.

V_ACAD_ORG PS_V_ACAD_ORG L26_ID PS_ACAD_ORG_TBL, PS_CAMPUS_TBL, Tree

Academic Organization Level 25 Desc

This is the description for the academic organization hierarchy level 25.

V_ACAD_ORG PS_V_ACAD_ORG L25_DESC PS_ACAD_ORG_TBL, PS_CAMPUS_TBL, Tree

Academic Organization Level 25 Id

This is the identifier for the academic organization hierarchy level 25.

V_ACAD_ORG PS_V_ACAD_ORG L25_ID PS_ACAD_ORG_TBL, PS_CAMPUS_TBL, Tree

Monday, May 13, 2013 Page 8 of 47

Page 9: Campus Solutions Subject Area Dictionary · Presentation Table Presentation Column Presentation Description Logical Table Source ETL Logic and Logical Expression from Business Layer

CSW - Student Records - Term Enrollment

Presentation Table

Presentation Column Presentation Description Logical Table Source

ETL Logic and Logical Expression from Business Layer (if applicable)

Physical Table Physical Column PeopleSoft Table

Academic Organization

Academic Organization Level 24 Desc

This is the description for the academic organization hierarchy level 24.

V_ACAD_ORG PS_V_ACAD_ORG L24_DESC PS_ACAD_ORG_TBL, PS_CAMPUS_TBL, Tree

Academic Organization Level 24 Id

This is the identifier for the academic organization hierarchy level 24.

V_ACAD_ORG PS_V_ACAD_ORG L24_ID PS_ACAD_ORG_TBL, PS_CAMPUS_TBL, Tree

Academic Organization Level 23 Desc

This is the description for the academic organization hierarchy level 23.

V_ACAD_ORG PS_V_ACAD_ORG L23_DESC PS_ACAD_ORG_TBL, PS_CAMPUS_TBL, Tree

Academic Organization Level 23 Id

This is the identifier for the academic organization hierarchy level 23.

V_ACAD_ORG PS_V_ACAD_ORG L23_ID PS_ACAD_ORG_TBL, PS_CAMPUS_TBL, Tree

Academic Organization Level 22 Desc

This is the description for the academic organization hierarchy level 22.

V_ACAD_ORG PS_V_ACAD_ORG L22_DESC PS_ACAD_ORG_TBL, PS_CAMPUS_TBL, Tree

Academic Organization Level 15 Desc

This is the description for the academic organization hierarchy level 15.

V_ACAD_ORG PS_V_ACAD_ORG L15_DESC PS_ACAD_ORG_TBL, PS_CAMPUS_TBL, Tree

Academic Organization Level 21 Desc

This is the description for the academic organization hierarchy level 21.

V_ACAD_ORG PS_V_ACAD_ORG L21_DESC PS_ACAD_ORG_TBL, PS_CAMPUS_TBL, Tree

Academic Organization Level 16 Id

This is the identifier for the academic organization hierarchy level 16.

V_ACAD_ORG PS_V_ACAD_ORG L16_ID PS_ACAD_ORG_TBL, PS_CAMPUS_TBL, Tree

Academic Organization Level 20 Desc

This is the description for the academic organization hierarchy level 20.

V_ACAD_ORG PS_V_ACAD_ORG L20_DESC PS_ACAD_ORG_TBL, PS_CAMPUS_TBL, Tree

Monday, May 13, 2013 Page 9 of 47

Page 10: Campus Solutions Subject Area Dictionary · Presentation Table Presentation Column Presentation Description Logical Table Source ETL Logic and Logical Expression from Business Layer

CSW - Student Records - Term Enrollment

Presentation Table

Presentation Column Presentation Description Logical Table Source

ETL Logic and Logical Expression from Business Layer (if applicable)

Physical Table Physical Column PeopleSoft Table

Academic Organization

Academic Organization Level 20 Id

This is the identifier for the academic organization hierarchy level 20.

V_ACAD_ORG PS_V_ACAD_ORG L20_ID PS_ACAD_ORG_TBL, PS_CAMPUS_TBL, Tree

Academic Organization Level 19 Desc

This is the description for the academic organization hierarchy level 19.

V_ACAD_ORG PS_V_ACAD_ORG L19_DESC PS_ACAD_ORG_TBL, PS_CAMPUS_TBL, Tree

Academic Organization Level 19 Id

This is the identifier for the academic organization hierarchy level 19.

V_ACAD_ORG PS_V_ACAD_ORG L19_ID PS_ACAD_ORG_TBL, PS_CAMPUS_TBL, Tree

Academic Organization Level 18 Desc

This is the description for the academic organization hierarchy level 18.

V_ACAD_ORG PS_V_ACAD_ORG L18_DESC PS_ACAD_ORG_TBL, PS_CAMPUS_TBL, Tree

Academic Organization Level 18 Id

This is the identifier for the academic organization hierarchy level 18.

V_ACAD_ORG PS_V_ACAD_ORG L18_ID PS_ACAD_ORG_TBL, PS_CAMPUS_TBL, Tree

Academic Organization Level 17 Desc

This is the description for the academic organization hierarchy level 17.

V_ACAD_ORG PS_V_ACAD_ORG L17_DESC PS_ACAD_ORG_TBL, PS_CAMPUS_TBL, Tree

Academic Organization Level 17 Id

This is the identifier for the academic organization hierarchy level 17.

V_ACAD_ORG PS_V_ACAD_ORG L17_ID PS_ACAD_ORG_TBL, PS_CAMPUS_TBL, Tree

Academic Organization Level 27 Id

This is the identifier for the academic organization hierarchy level 27.

V_ACAD_ORG PS_V_ACAD_ORG L27_ID PS_ACAD_ORG_TBL, PS_CAMPUS_TBL, Tree

Academic Organization Level 22 Id

This is the identifier for the academic organization hierarchy level 22.

V_ACAD_ORG PS_V_ACAD_ORG L22_ID PS_ACAD_ORG_TBL, PS_CAMPUS_TBL, Tree

Monday, May 13, 2013 Page 10 of 47

Page 11: Campus Solutions Subject Area Dictionary · Presentation Table Presentation Column Presentation Description Logical Table Source ETL Logic and Logical Expression from Business Layer

CSW - Student Records - Term Enrollment

Presentation Table

Presentation Column Presentation Description Logical Table Source

ETL Logic and Logical Expression from Business Layer (if applicable)

Physical Table Physical Column PeopleSoft Table

Academic Plan

Institution Code This is the code that identifies an academic institution.

D_ACAD_PLAN PS_D_ACAD_PLAN INSTITUTION_CD PS_ACAD_PLAN_TBL

Academic Group Code This is the code that identifies an academic group.

D_ACAD_PLAN PS_D_ACAD_PLAN ACAD_GRP_CD PS_ACAD_PLAN_TBL

Institution Desc This is the long description that identifies an academic institution.

D_ACAD_PLAN PS_D_ACAD_PLAN INSTITUTION_LD PS_ACAD_PLAN_TBL

Current Indicator The current row indicator. D_ACAD_PLAN PS_D_ACAD_PLAN CURRENT_IND

Study Field Desc This is the long description of the field of study of an academic plan.

D_ACAD_PLAN PS_D_ACAD_PLAN STUDY_FLD_LD PS_ACAD_PLAN_TBL

Study Field This is the short description of the field of study of an academic plan.

D_ACAD_PLAN PS_D_ACAD_PLAN STUDY_FLD_SD PS_ACAD_PLAN_TBL

Study Field Code This is the identification code of the field of study of an academic plan.

D_ACAD_PLAN PS_D_ACAD_PLAN STUDY_FLD_CD PS_ACAD_PLAN_TBL

Academic Plan Type Desc

This is the long description for the type of an academic plan.

D_ACAD_PLAN PS_D_ACAD_PLAN ACAD_PLAN_TYPE_LD

PS_ACAD_PLAN_TBL

Academic Plan Type This is the short description for the type of an academic plan.

D_ACAD_PLAN PS_D_ACAD_PLAN ACAD_PLAN_TYPE_SD

PS_ACAD_PLAN_TBL

Academic Plan Type Code

This is the code for the type of an academic plan.

D_ACAD_PLAN PS_D_ACAD_PLAN ACAD_PLAN_TYPE_CD

PS_ACAD_PLAN_TBL

Institution This is the short description that identifies an academic institution.

D_ACAD_PLAN PS_D_ACAD_PLAN INSTITUTION_SD PS_ACAD_PLAN_TBL

Monday, May 13, 2013 Page 11 of 47

Page 12: Campus Solutions Subject Area Dictionary · Presentation Table Presentation Column Presentation Description Logical Table Source ETL Logic and Logical Expression from Business Layer

CSW - Student Records - Term Enrollment

Presentation Table

Presentation Column Presentation Description Logical Table Source

ETL Logic and Logical Expression from Business Layer (if applicable)

Physical Table Physical Column PeopleSoft Table

Academic Plan

Academic Group This is the short description that identifies an academic group.

D_ACAD_PLAN PS_D_ACAD_PLAN ACAD_GRP_SD PS_ACAD_PLAN_TBL

Academic Career Desc This is the long description that identifies an academic career.

D_ACAD_PLAN PS_D_ACAD_PLAN ACAD_CAR_LD PS_ACAD_PLAN_TBL

Academic Career This is the short description of the academic career.

D_ACAD_PLAN PS_D_ACAD_PLAN ACAD_CAR_SD PS_ACAD_PLAN_TBL

Academic Career Code

This is the code that identifies an academic career.

D_ACAD_PLAN PS_D_ACAD_PLAN ACAD_CAR_CD PS_ACAD_PLAN_TBL

Academic Program Desc

This is the long description that identifies an academic program.

D_ACAD_PLAN PS_D_ACAD_PLAN ACAD_PROG_LD PS_ACAD_PLAN_TBL

Academic Program This is the short description that identifies an academic program.

D_ACAD_PLAN PS_D_ACAD_PLAN ACAD_PROG_SD PS_ACAD_PLAN_TBL

Academic Program Code

This is the code that identifies an academic program .

D_ACAD_PLAN PS_D_ACAD_PLAN ACAD_PROG_CD PS_ACAD_PLAN_TBL

Academic Plan Desc This is the long description for an academic plan.

D_ACAD_PLAN PS_D_ACAD_PLAN ACAD_PLAN_LD PS_ACAD_PLAN_TBL

Academic Plan This is the short description for an academic plan.

D_ACAD_PLAN PS_D_ACAD_PLAN ACAD_PLAN_SD PS_ACAD_PLAN_TBL

Academic Plan Code This is the code that identifies an academic plan.

D_ACAD_PLAN PS_D_ACAD_PLAN ACAD_PLAN_CD PS_ACAD_PLAN_TBL

Source System Id The source system from where the data originated.

D_ACAD_PLAN PS_D_ACAD_PLAN SRC_SYS_ID PS_ACAD_PLAN_TBL

Academic Group Desc This is the long description that identifies an academic group.

D_ACAD_PLAN PS_D_ACAD_PLAN ACAD_GRP_LD PS_ACAD_PLAN_TBL

Academic Program

Monday, May 13, 2013 Page 12 of 47

Page 13: Campus Solutions Subject Area Dictionary · Presentation Table Presentation Column Presentation Description Logical Table Source ETL Logic and Logical Expression from Business Layer

CSW - Student Records - Term Enrollment

Presentation Table

Presentation Column Presentation Description Logical Table Source

ETL Logic and Logical Expression from Business Layer (if applicable)

Physical Table Physical Column PeopleSoft Table

Academic Program

Academic Program This is the short description that identifies an academic program.

D_ACAD_PROG PS_D_ACAD_PROG ACAD_PROG_SD PS_ACAD_PROG_TBL

Academic Program Code

This is the code that identifies an academic program .

D_ACAD_PROG PS_D_ACAD_PROG ACAD_PROG_CD PS_ACAD_PROG_TBL

Normal Completion Year

This is the normal completion time for an academic program.

D_ACAD_PROG PS_D_ACAD_PROG NORM_CMPLTN_YR_NUM

PS_ACAD_PROG_TBL

Academic Organization Desc

This is the long description for the academic organization.

D_ACAD_PROG PS_D_ACAD_PROG ACAD_ORG_LD PS_ACAD_PROG_TBL

Institution Code This is the code that identifies an academic institution.

D_ACAD_PROG PS_D_ACAD_PROG INSTITUTION_CD PS_ACAD_PROG_TBL

Institution This is the short description that identifies an academic institution.

D_ACAD_PROG PS_D_ACAD_PROG INSTITUTION_SD PS_ACAD_PROG_TBL

Institution Desc This is the long description that identifies an academic institution.

D_ACAD_PROG PS_D_ACAD_PROG INSTITUTION_LD PS_ACAD_PROG_TBL

Academic Calendar Id This is the identification number of the academic calendar.

D_ACAD_PROG PS_D_ACAD_PROG ACAD_CAL_ID PS_ACAD_PROG_TBL

Academic Calendar This is the short description of the academic calendar.

D_ACAD_PROG PS_D_ACAD_PROG ACAD_CAL_SD PS_ACAD_PROG_TBL

Academic Calendar Desc

This is the long description of the academic calendar.

D_ACAD_PROG PS_D_ACAD_PROG ACAD_CAL_LD PS_ACAD_PROG_TBL

CIP Code This is the CIP code for an an academic program .

D_ACAD_PROG PS_D_ACAD_PROG CIP_CD PS_ACAD_PROG_TBL

CIP Desc This is the long description for the Classification of Institutional Programs (CIP) code.

D_ACAD_PROG PS_D_ACAD_PROG CIP_LD PS_ACAD_PROG_TBL

Monday, May 13, 2013 Page 13 of 47

Page 14: Campus Solutions Subject Area Dictionary · Presentation Table Presentation Column Presentation Description Logical Table Source ETL Logic and Logical Expression from Business Layer

CSW - Student Records - Term Enrollment

Presentation Table

Presentation Column Presentation Description Logical Table Source

ETL Logic and Logical Expression from Business Layer (if applicable)

Physical Table Physical Column PeopleSoft Table

Academic Program

HEGIS Code This is the code for Higher Education General Information Survey (HEGIS).

D_ACAD_PROG PS_D_ACAD_PROG HEGIS_CD PS_ACAD_PROG_TBL

Source System Id The source system from where the data originated.

D_ACAD_PROG PS_D_ACAD_PROG SRC_SYS_ID PS_ACAD_PROG_TBL

Residency Requirement Indicator

This is the residency required flag for an academic program.

D_ACAD_PROG PS_D_ACAD_PROG RES_REQ_FLG PS_ACAD_PROG_TBL

Academic Organization

This is the short description for the academic organization.

D_ACAD_PROG PS_D_ACAD_PROG ACAD_ORG_SD PS_ACAD_PROG_TBL

Current Indicator The current row indicator. D_ACAD_PROG PS_D_ACAD_PROG CURRENT_IND

Academic Organization Code

This is the code that identifies an academic organization.

D_ACAD_PROG PS_D_ACAD_PROG ACAD_ORG_CD PS_ACAD_PROG_TBL

Academic Group Desc This is the long description that identifies an academic group.

D_ACAD_PROG PS_D_ACAD_PROG ACAD_GRP_LD PS_ACAD_PROG_TBL

Academic Group This is the short description that identifies an academic group.

D_ACAD_PROG PS_D_ACAD_PROG ACAD_GRP_SD PS_ACAD_PROG_TBL

Academic Group Code This is the code that identifies an academic group.

D_ACAD_PROG PS_D_ACAD_PROG ACAD_GRP_CD PS_ACAD_PROG_TBL

Academic Career Desc This is the long description that identifies an academic career.

D_ACAD_PROG PS_D_ACAD_PROG ACAD_CAR_LD PS_ACAD_PROG_TBL

Academic Career This is the short description of the academic career.

D_ACAD_PROG PS_D_ACAD_PROG ACAD_CAR_SD PS_ACAD_PROG_TBL

Academic Career Code

This is the code that identifies an academic career.

D_ACAD_PROG PS_D_ACAD_PROG ACAD_CAR_CD PS_ACAD_PROG_TBL

Monday, May 13, 2013 Page 14 of 47

Page 15: Campus Solutions Subject Area Dictionary · Presentation Table Presentation Column Presentation Description Logical Table Source ETL Logic and Logical Expression from Business Layer

CSW - Student Records - Term Enrollment

Presentation Table

Presentation Column Presentation Description Logical Table Source

ETL Logic and Logical Expression from Business Layer (if applicable)

Physical Table Physical Column PeopleSoft Table

Academic Program

Academic Program Desc

This is the long description that identifies an academic program.

D_ACAD_PROG PS_D_ACAD_PROG ACAD_PROG_LD PS_ACAD_PROG_TBL

HEGIS Desc This is the long description for Higher Education General Information Survey (HEGIS).

D_ACAD_PROG PS_D_ACAD_PROG HEGIS_LD PS_ACAD_PROG_TBL

Academic Standing

Academic Standing Status Desc

This is the long description that identifies the status of an academic standing action.

D_ACAD_STNDNG PS_D_ACAD_STNDNG STNDNG_STAT_LD PS_ACAD_STACTN_TBL

Institution This is the short description that identifies an academic institution.

D_ACAD_STNDNG PS_D_ACAD_STNDNG INSTITUTION_SD PS_ACAD_STACTN_TBL

Academic Career This is the short description of the academic career.

D_ACAD_STNDNG PS_D_ACAD_STNDNG ACAD_CAR_SD PS_ACAD_STACTN_TBL

Institution Desc This is the long description that identifies an academic institution.

D_ACAD_STNDNG PS_D_ACAD_STNDNG INSTITUTION_LD PS_ACAD_STACTN_TBL

Institution Code This is the code that identifies an academic institution.

D_ACAD_STNDNG PS_D_ACAD_STNDNG INSTITUTION_CD PS_ACAD_STACTN_TBL

Academic Career Desc This is the long description that identifies an academic career.

D_ACAD_STNDNG PS_D_ACAD_STNDNG ACAD_CAR_LD PS_ACAD_STACTN_TBL

Academic Career Code

This is the code that identifies an academic career.

D_ACAD_STNDNG PS_D_ACAD_STNDNG ACAD_CAR_CD PS_ACAD_STACTN_TBL

Academic Standing Status

This is the short description that identifies the status of an academic standing action.

D_ACAD_STNDNG PS_D_ACAD_STNDNG STNDNG_STAT_SD PS_ACAD_STACTN_TBL

Monday, May 13, 2013 Page 15 of 47

Page 16: Campus Solutions Subject Area Dictionary · Presentation Table Presentation Column Presentation Description Logical Table Source ETL Logic and Logical Expression from Business Layer

CSW - Student Records - Term Enrollment

Presentation Table

Presentation Column Presentation Description Logical Table Source

ETL Logic and Logical Expression from Business Layer (if applicable)

Physical Table Physical Column PeopleSoft Table

Academic Standing

Academic Standing Status Code

This is the code that identifies the status of an academic standing action.

D_ACAD_STNDNG PS_D_ACAD_STNDNG STNDNG_STAT_CD PS_ACAD_STACTN_TBL

Academic Standing Action Desc

This is the long description that identifies an academic standing action.

D_ACAD_STNDNG PS_D_ACAD_STNDNG ACAD_STNDNG_ACN_LD

PS_ACAD_STACTN_TBL

Academic Standing Action

This is the short description that identifies an academic standing action.

D_ACAD_STNDNG PS_D_ACAD_STNDNG ACAD_STNDNG_ACN_SD

PS_ACAD_STACTN_TBL

Academic Standing Action Code

This is the code that identifies an academic standing action.

D_ACAD_STNDNG PS_D_ACAD_STNDNG ACAD_STNDNG_ACN_CD

PS_ACAD_STACTN_TBL

Source System Id The source system from where the data originated.

D_ACAD_STNDNG PS_D_ACAD_STNDNG SRC_SYS_ID PS_ACAD_STACTN_TBL

Current Indicator The current row indicator. D_ACAD_STNDNG PS_D_ACAD_STNDNG CURRENT_IND

Class Rank Number

Class Rank Number This is the number that indicated the rank of the student in a given class.

F_TERM_ENRLMT PS_F_TERM_ENRLMT CLASS_RANK_NUM PS_STDNT_CAR_TERM, PS_TERM_TBL

Day Fully Enroll Date

Fully Enroll Week Year Number

The week year number. D_DAY_Fully_Enroll_Date PS_D_DAY WEEK_YR_NUM

Fully Enroll Day Julian Yyy

The Julian Yyy day. D_DAY_Fully_Enroll_Date PS_D_DAY DAY_JULIAN_YYY

Monday, May 13, 2013 Page 16 of 47

Page 17: Campus Solutions Subject Area Dictionary · Presentation Table Presentation Column Presentation Description Logical Table Source ETL Logic and Logical Expression from Business Layer

CSW - Student Records - Term Enrollment

Presentation Table

Presentation Column Presentation Description Logical Table Source

ETL Logic and Logical Expression from Business Layer (if applicable)

Physical Table Physical Column PeopleSoft Table

Day Fully Enroll Date

Fully Enroll Day Week Number

This is the week number of the week in which the day falls.

D_DAY_Fully_Enroll_Date PS_D_DAY DAY_WK_NUM

Fully Enroll Day Month Number

This is the day of the month. D_DAY_Fully_Enroll_Date PS_D_DAY DAY_MTH_NUM

Fully Enroll Day Year Number

This is the year number of the year in which the day falls.

D_DAY_Fully_Enroll_Date PS_D_DAY DAY_YR_NUM

Fully Enroll Week Number

This is the week number. D_DAY_Fully_Enroll_Date PS_D_DAY WEEK_NUM

Fully Enroll Week Month Number

The week month number. D_DAY_Fully_Enroll_Date PS_D_DAY WEEK_MTH_NUM

Fully Enroll Day Desc This is the description of the day. D_DAY_Fully_Enroll_Date PS_D_DAY DAY_DESCR

Fully Enroll Month Number

The month number. D_DAY_Fully_Enroll_Date PS_D_DAY MONTH_NUM

Fully Enroll Quarter Desc

This is the description of the quarter.

D_DAY_Fully_Enroll_Date PS_D_DAY QUARTER_DESCR

Fully Enroll Month Desc

This is the description of the month.

D_DAY_Fully_Enroll_Date PS_D_DAY MONTH_DESCR

Fully Enroll Quarter Abbreviation

This is the abbreviation for the quarter.

D_DAY_Fully_Enroll_Date PS_D_DAY QUARTER_ABBR

Fully Enroll Month Abbreviation

This is abbreviation of the month. D_DAY_Fully_Enroll_Date PS_D_DAY MONTH_ABBR

Fully Enroll Month Quarter Number

This is the month of the quarter. D_DAY_Fully_Enroll_Date PS_D_DAY MONTH_QTR_NUM

Fully Enroll Month Year Number

The month year number. D_DAY_Fully_Enroll_Date PS_D_DAY MONTH_YR_NUM

Monday, May 13, 2013 Page 17 of 47

Page 18: Campus Solutions Subject Area Dictionary · Presentation Table Presentation Column Presentation Description Logical Table Source ETL Logic and Logical Expression from Business Layer

CSW - Student Records - Term Enrollment

Presentation Table

Presentation Column Presentation Description Logical Table Source

ETL Logic and Logical Expression from Business Layer (if applicable)

Physical Table Physical Column PeopleSoft Table

Day Fully Enroll Date

Fully Enroll Week Desc

This is the description of the week.

D_DAY_Fully_Enroll_Date PS_D_DAY WEEK_DESCR

Fully Enroll Year Desc This is the description of the year.

D_DAY_Fully_Enroll_Date PS_D_DAY YEAR_DESCR

Fully Enroll Day Weekend Indicator

This is the indicator to denote that the day is weekend day.

D_DAY_Fully_Enroll_Date PS_D_DAY DAY_WEEKEND_FLG

Fully Enroll First Day in Year Indicator

This is the indicator to denote first day of the year.

D_DAY_Fully_Enroll_Date PS_D_DAY FIRSTDAYYR_FLG

Fully Enroll Last Day in Quarter Indicator

This is the indicator to denote the last day of the quarter.

D_DAY_Fully_Enroll_Date PS_D_DAY LASTDAYQTR_FLG

Fully Enroll First Day in Quarter Indicator

This is the indicator to denote the first day of quarter.

D_DAY_Fully_Enroll_Date PS_D_DAY FIRSTDAYQTR_FLG

Fully Enroll Last Day in Month Indicator

This is indicator to denote last day of the month.

D_DAY_Fully_Enroll_Date PS_D_DAY LASTDAYMTH_FLG

Fully Enroll First Day in Month Indicator

This is the indicator to denote first day of the month.

D_DAY_Fully_Enroll_Date PS_D_DAY FIRSTDAYMTH_FLG

Fully Enroll Day Julian The Julian day. D_DAY_Fully_Enroll_Date PS_D_DAY DAY_JULIAN

Fully Enroll First Day in Week Indicator

This is the indicator to denote first day of the week.

D_DAY_Fully_Enroll_Date PS_D_DAY FIRSTDAYWK_FLG

Fully Enroll Day Abbreviation

This is the abbreviation of the day.

D_DAY_Fully_Enroll_Date PS_D_DAY DAY_ABBR

Fully Enroll Year Number

The year number. D_DAY_Fully_Enroll_Date PS_D_DAY YEAR_NUM

Fully Enroll Quarter Year Number

This is the quarter of year. D_DAY_Fully_Enroll_Date PS_D_DAY QUARTER_YR_NUM

Monday, May 13, 2013 Page 18 of 47

Page 19: Campus Solutions Subject Area Dictionary · Presentation Table Presentation Column Presentation Description Logical Table Source ETL Logic and Logical Expression from Business Layer

CSW - Student Records - Term Enrollment

Presentation Table

Presentation Column Presentation Description Logical Table Source

ETL Logic and Logical Expression from Business Layer (if applicable)

Physical Table Physical Column PeopleSoft Table

Day Fully Enroll Date

Fully Enroll Quarter Number

This is the quarter number. D_DAY_Fully_Enroll_Date PS_D_DAY QUARTER_NUM

Fully Enroll Day Date This is the calendar date. D_DAY_Fully_Enroll_Date PS_D_DAY DAY_DT PS_STDNT_CAR_TERM

Fully Enroll Day Number

This is the day number within the entire calendar date range.

D_DAY_Fully_Enroll_Date PS_D_DAY DAY_NUM

Fully Enroll Last Day in Year Indicator

This is the indicator to denote the last day of the year.

D_DAY_Fully_Enroll_Date PS_D_DAY LASTDAYYR_FLG

Fully Enroll Last Day in Week Indicator

This is the indicator to denote the last day of the week.

D_DAY_Fully_Enroll_Date PS_D_DAY LASTDAYWK_FLG

Day Withdrawn Date

Withdrawn Last Day in Month Indicator

This is indicator to denote last day of the month.

D_DAY_Withdrawn_Date PS_D_DAY LASTDAYMTH_FLG

Withdrawn Day Week Number

This is the week number of the week in which the day falls.

D_DAY_Withdrawn_Date PS_D_DAY DAY_WK_NUM

Withdrawn Month Number

The month number. D_DAY_Withdrawn_Date PS_D_DAY MONTH_NUM

Withdrawn Last Day in Quarter Indicator

This is the indicator to denote the last day of the quarter.

D_DAY_Withdrawn_Date PS_D_DAY LASTDAYQTR_FLG

Withdrawn Week Month Number

The week month number. D_DAY_Withdrawn_Date PS_D_DAY WEEK_MTH_NUM

Withdrawn Week Desc

This is the description of the week.

D_DAY_Withdrawn_Date PS_D_DAY WEEK_DESCR

Withdrawn Week Number

This is the week number. D_DAY_Withdrawn_Date PS_D_DAY WEEK_NUM

Monday, May 13, 2013 Page 19 of 47

Page 20: Campus Solutions Subject Area Dictionary · Presentation Table Presentation Column Presentation Description Logical Table Source ETL Logic and Logical Expression from Business Layer

CSW - Student Records - Term Enrollment

Presentation Table

Presentation Column Presentation Description Logical Table Source

ETL Logic and Logical Expression from Business Layer (if applicable)

Physical Table Physical Column PeopleSoft Table

Day Withdrawn Date

Withdrawn Day Weekend Indicator

This is the indicator to denote that the day is weekend day.

D_DAY_Withdrawn_Date PS_D_DAY DAY_WEEKEND_FLG

Withdrawn Day Month Number

This is the day of the month. D_DAY_Withdrawn_Date PS_D_DAY DAY_MTH_NUM

Withdrawn Month Desc

This is the description of the month.

D_DAY_Withdrawn_Date PS_D_DAY MONTH_DESCR

Withdrawn Day Julian Yyy

The Julian Yyy day. D_DAY_Withdrawn_Date PS_D_DAY DAY_JULIAN_YYY

Withdrawn Day Julian The Julian day. D_DAY_Withdrawn_Date PS_D_DAY DAY_JULIAN

Withdrawn Day Abbreviation

This is the abbreviation of the day.

D_DAY_Withdrawn_Date PS_D_DAY DAY_ABBR

Withdrawn Day Desc This is the description of the day. D_DAY_Withdrawn_Date PS_D_DAY DAY_DESCR

Withdrawn Day Number

This is the day number within the entire calendar date range.

D_DAY_Withdrawn_Date PS_D_DAY DAY_NUM

Withdrawn Day Date This is the calendar date. D_DAY_Withdrawn_Date PS_D_DAY DAY_DT PS_STDNT_CAR_TERM

Withdrawn Day Year Number

This is the year number of the year in which the day falls.

D_DAY_Withdrawn_Date PS_D_DAY DAY_YR_NUM

Withdrawn First Day in Week Indicator

This is the indicator to denote first day of the week.

D_DAY_Withdrawn_Date PS_D_DAY FIRSTDAYWK_FLG

Withdrawn Last Day in Year Indicator

This is the indicator to denote the last day of the year.

D_DAY_Withdrawn_Date PS_D_DAY LASTDAYYR_FLG

Withdrawn First Day in Year Indicator

This is the indicator to denote first day of the year.

D_DAY_Withdrawn_Date PS_D_DAY FIRSTDAYYR_FLG

Withdrawn First Day in Quarter Indicator

This is the indicator to denote the first day of quarter.

D_DAY_Withdrawn_Date PS_D_DAY FIRSTDAYQTR_FLG

Monday, May 13, 2013 Page 20 of 47

Page 21: Campus Solutions Subject Area Dictionary · Presentation Table Presentation Column Presentation Description Logical Table Source ETL Logic and Logical Expression from Business Layer

CSW - Student Records - Term Enrollment

Presentation Table

Presentation Column Presentation Description Logical Table Source

ETL Logic and Logical Expression from Business Layer (if applicable)

Physical Table Physical Column PeopleSoft Table

Day Withdrawn Date

Withdrawn First Day in Month Indicator

This is the indicator to denote first day of the month.

D_DAY_Withdrawn_Date PS_D_DAY FIRSTDAYMTH_FLG

Withdrawn Week Year Number

The week year number. D_DAY_Withdrawn_Date PS_D_DAY WEEK_YR_NUM

Withdrawn Last Day in Week Indicator

This is the indicator to denote the last day of the week.

D_DAY_Withdrawn_Date PS_D_DAY LASTDAYWK_FLG

Withdrawn Month Abbreviation

This is abbreviation of the month. D_DAY_Withdrawn_Date PS_D_DAY MONTH_ABBR

Withdrawn Year Desc This is the description of the year.

D_DAY_Withdrawn_Date PS_D_DAY YEAR_DESCR

Withdrawn Year Number

The year number. D_DAY_Withdrawn_Date PS_D_DAY YEAR_NUM

Withdrawn Quarter Year Number

This is the quarter of year. D_DAY_Withdrawn_Date PS_D_DAY QUARTER_YR_NUM

Withdrawn Quarter Abbreviation

This is the abbreviation for the quarter.

D_DAY_Withdrawn_Date PS_D_DAY QUARTER_ABBR

Withdrawn Quarter Desc

This is the description of the quarter.

D_DAY_Withdrawn_Date PS_D_DAY QUARTER_DESCR

Withdrawn Quarter Number

This is the quarter number. D_DAY_Withdrawn_Date PS_D_DAY QUARTER_NUM

Withdrawn Month Year Number

The month year number. D_DAY_Withdrawn_Date PS_D_DAY MONTH_YR_NUM

Withdrawn Month Quarter Number

This is the month of the quarter. D_DAY_Withdrawn_Date PS_D_DAY MONTH_QTR_NUM

Document Details

Monday, May 13, 2013 Page 21 of 47

Page 22: Campus Solutions Subject Area Dictionary · Presentation Table Presentation Column Presentation Description Logical Table Source ETL Logic and Logical Expression from Business Layer

CSW - Student Records - Term Enrollment

Presentation Table

Presentation Column Presentation Description Logical Table Source

ETL Logic and Logical Expression from Business Layer (if applicable)

Physical Table Physical Column PeopleSoft Table

Document Details

Source System Id The source system from where the data originated.

F_TERM_ENRLMT PS_F_TERM_ENRLMT SRC_SYS_ID PS_STDNT_CAR_TERM, PS_TERM_TBL

Ethnicity

Current Indicator This is the Current Indicator. D_ETHNICITY PS_D_ETHNICITY CURRENT_IND

Ethnic Percentage - Numerator

This is the Ethnic Percentage - Numerator.

D_ETHNICITY PS_D_ETHNICITY ETHNIC_PCT_NUMRATR

PS_DIVERS_ETHNIC, PS_ETHNICITY_DTL

Ethnicity Validation Flag

This is the Ethnicity Validation Flag.

D_ETHNICITY PS_D_ETHNICITY IPEDS_FLG PS_DIVERS_ETHNIC, PS_ETHNICITY_DTL

Hispanic/Latino Flag This is the flag to indicate whether a person is Hispanic or Latino.

D_ETHNICITY PS_D_ETHNICITY HISP_LATINO_FLG PS_DIVERS_ETHNIC, PS_ETHNICITY_DTL

Source Setid This is the Source Setid. D_ETHNICITY PS_D_ETHNICITY SRC_SETID PS_DIVERS_ETHNIC, PS_ETHNICITY_DTL

Regulatory Region This is the Regulatory Region. D_ETHNICITY PS_D_ETHNICITY REG_REGION PS_DIVERS_ETHNIC, PS_ETHNICITY_DTL

Ethnic Percentage - Denominator

This is the Ethnic Percentage - Denominator.

D_ETHNICITY PS_D_ETHNICITY ETHNIC_PCT_DENMRTR

PS_DIVERS_ETHNIC, PS_ETHNICITY_DTL

Ethnic Group Code This is the Ethnic group code. D_ETHNICITY PS_D_ETHNICITY ETHNIC_GRP_CD PS_DIVERS_ETHNIC, PS_ETHNICITY_DTL

Employee ID This is the Employee ID. D_ETHNICITY PS_D_ETHNICITY EMPLID PS_DIVERS_ETHNIC, PS_ETHNICITY_DTL

Setid This is the SetId. D_ETHNICITY PS_D_ETHNICITY SETID PS_DIVERS_ETHNIC, PS_ETHNICITY_DTL

Last Update Date/Time

This is the Last Update Date/Time D_ETHNICITY PS_D_ETHNICITY LASTUPDDTTM PS_DIVERS_ETHNIC, PS_ETHNICITY_DTL

Monday, May 13, 2013 Page 22 of 47

Page 23: Campus Solutions Subject Area Dictionary · Presentation Table Presentation Column Presentation Description Logical Table Source ETL Logic and Logical Expression from Business Layer

CSW - Student Records - Term Enrollment

Presentation Table

Presentation Column Presentation Description Logical Table Source

ETL Logic and Logical Expression from Business Layer (if applicable)

Physical Table Physical Column PeopleSoft Table

Ethnicity

Last Update Oprid This is the Last Update Oprid. D_ETHNICITY PS_D_ETHNICITY LASTUPDOPRID PS_DIVERS_ETHNIC, PS_ETHNICITY_DTL

Primary Flag This is the Primary Flag. D_ETHNICITY PS_D_ETHNICITY PRIMARY_FLAG PS_DIVERS_ETHNIC, PS_ETHNICITY_DTL

Source System Id This is the Source System Identifier.

D_ETHNICITY PS_D_ETHNICITY SRC_SYS_ID PS_DIVERS_ETHNIC, PS_ETHNICITY_DTL

Fact Term Enrollment

Current Grade Point Average

This is the current Grade Point Average (GPA) of a student in a term.

F_TERM_ENRLMT PS_F_TERM_ENRLMT CUR_GPA_PTS PS_STDNT_CAR_TERM, PS_TERM_TBL

Units Passed for Grade Point Average

This is the units passed for Grade Point Average (GPA) by the student.

F_TERM_ENRLMT PS_F_TERM_ENRLMT PASSD_GPA_UNIT PS_STDNT_CAR_TERM, PS_TERM_TBL

Grade Points This is the grade points earned by the student.

F_TERM_ENRLMT PS_F_TERM_ENRLMT GRADE_PTS PS_STDNT_CAR_TERM, PS_TERM_TBL

Cumulative Grade Point Average

This is the cumulative Grade Point Average (GPA) of the student.

F_TERM_ENRLMT PS_F_TERM_ENRLMT CUM_GPA_PTS PS_STDNT_CAR_TERM, PS_TERM_TBL

Units Taken in Progress

This is the units progressed by the student.

F_TERM_ENRLMT PS_F_TERM_ENRLMT TAKEN_PRGRS_UNIT PS_STDNT_CAR_TERM, PS_TERM_TBL

Units Taken for Grade Point Average

This is the units taken for Grade Point Average (GPA) by the student.

F_TERM_ENRLMT PS_F_TERM_ENRLMT TAKEN_GPA_UNIT PS_STDNT_CAR_TERM, PS_TERM_TBL

Units Taken for Non Grade Point Average

This is the units taken for non Grade Point Average (GPA) by the student.

F_TERM_ENRLMT PS_F_TERM_ENRLMT TAKEN_NON_GPA_UNIT

PS_STDNT_CAR_TERM, PS_TERM_TBL

Monday, May 13, 2013 Page 23 of 47

Page 24: Campus Solutions Subject Area Dictionary · Presentation Table Presentation Column Presentation Description Logical Table Source ETL Logic and Logical Expression from Business Layer

CSW - Student Records - Term Enrollment

Presentation Table

Presentation Column Presentation Description Logical Table Source

ETL Logic and Logical Expression from Business Layer (if applicable)

Physical Table Physical Column PeopleSoft Table

Fact Term Enrollment

Units Passed in Progress

This is the units passed by the student.

F_TERM_ENRLMT PS_F_TERM_ENRLMT PASSD_PRGRS_UNIT PS_STDNT_CAR_TERM, PS_TERM_TBL

Returning Indicator Flag Count

This is a flag to indicate if the student is a returning student for this term as compared to the previous term.

F_TERM_ENRLMT

" CASE ""Enterprise Warehouse""."""".""Enterprise Warehouse"".F_TERM_ENRLMT.RETURNING_FLG WHEN 'Y' THEN 1 ELSE 0 END "

PS_F_TERM_ENRLMT RETURNING_FLG

if HASH_PS_STDNT_ENRL_F_TERM_ENRLMT_lkp.COUNT>0 Then 'Y' Else 'N'

PS_STDNT_CAR_TERM, PS_TERM_TBL

Maximum Wait Units This is the maximum wait unit. F_TERM_ENRLMT PS_F_TERM_ENRLMT MAX_WAIT_UNIT PS_STDNT_CAR_TERM, PS_TERM_TBL

Term Enrollment Count

This is the distinct student term enrollment count.

F_TERM_ENRLMT PS_F_TERM_ENRLMT PERSON_SID PS_STDNT_CAR_TERM, PS_TERM_TBL

Row Count This is a dummy rowcount number which is always set to 1 and can be used for deriving various metrics.

F_TERM_ENRLMT PS_F_TERM_ENRLMT ROW_CNT

Course Count This is the total count of the courses taken by the student for a term.

F_TERM_ENRLMT PS_F_TERM_ENRLMT CRSE_CNT PS_STDNT_CAR_TERM, PS_TERM_TBL

Units Passed for Non Grade Point Average

This is the units passed for non Grade Point Average (GPA) by the student.

F_TERM_ENRLMT PS_F_TERM_ENRLMT PASSD_NON_GPA_UNIT

PS_STDNT_CAR_TERM, PS_TERM_TBL

Minimum Total Units This is the minimum total unit. F_TERM_ENRLMT PS_F_TERM_ENRLMT MIN_TOT_UNIT PS_STDNT_CAR_TERM, PS_TERM_TBL

Maximum Audit Units This is the maximum audit unit. F_TERM_ENRLMT PS_F_TERM_ENRLMT MAX_AUDIT_UNIT PS_STDNT_CAR_TERM, PS_TERM_TBL

Monday, May 13, 2013 Page 24 of 47

Page 25: Campus Solutions Subject Area Dictionary · Presentation Table Presentation Column Presentation Description Logical Table Source ETL Logic and Logical Expression from Business Layer

CSW - Student Records - Term Enrollment

Presentation Table

Presentation Column Presentation Description Logical Table Source

ETL Logic and Logical Expression from Business Layer (if applicable)

Physical Table Physical Column PeopleSoft Table

Fact Term Enrollment

Total Term Units This is the total term units. F_TERM_ENRLMT PS_F_TERM_ENRLMT TOT_TERM_UNIT PS_STDNT_CAR_TERM, PS_TERM_TBL

Maximum Total Units This is the maximum total unit. F_TERM_ENRLMT PS_F_TERM_ENRLMT MAX_TOT_UNIT PS_STDNT_CAR_TERM, PS_TERM_TBL

Units in Progress for Grade Point Average

This is the units in progress for Grade Point Average (GPA) by the student.

F_TERM_ENRLMT PS_F_TERM_ENRLMT PRGRS_GPA_UNIT PS_STDNT_CAR_TERM, PS_TERM_TBL

Other Units This is the units from other credits

F_TERM_ENRLMT PS_F_TERM_ENRLMT OTH_UNIT PS_STDNT_CAR_TERM, PS_TERM_TBL

Units in Progress for Non Grade Point Average

This is the units in progress for non Grade Point Average (GPA) by the student.

F_TERM_ENRLMT PS_F_TERM_ENRLMT PRGRS_NON_GPA_UNIT

PS_STDNT_CAR_TERM, PS_TERM_TBL

Maximum Units towards Non Grade Point Average

This is the maximum total unit not towards Grade Point Average (GPA).

F_TERM_ENRLMT PS_F_TERM_ENRLMT MAX_NON_GPA_UNIT

PS_STDNT_CAR_TERM, PS_TERM_TBL

Units Transferred This is the units transferred by the student.

F_TERM_ENRLMT PS_F_TERM_ENRLMT XFER_UNIT PS_STDNT_CAR_TERM, PS_TERM_TBL

Person

Military Grade Desc This is the military grade long description.

D_PERSON PS_D_PERSON MIL_GRD_LD PS_PERSON

Military Grade This is the military grade short description.

D_PERSON PS_D_PERSON MIL_GRD_SD PS_PERSON

Military Separation Status Code

This is the military separation status code of a person.

D_PERSON PS_D_PERSON MIL_SEP_STAT_CD PS_PERSON

Monday, May 13, 2013 Page 25 of 47

Page 26: Campus Solutions Subject Area Dictionary · Presentation Table Presentation Column Presentation Description Logical Table Source ETL Logic and Logical Expression from Business Layer

CSW - Student Records - Term Enrollment

Presentation Table

Presentation Column Presentation Description Logical Table Source

ETL Logic and Logical Expression from Business Layer (if applicable)

Physical Table Physical Column PeopleSoft Table

Person

Military Reserve Category Desc

This is the military reserve category long description.

D_PERSON PS_D_PERSON MIL_RSRV_CAT_LD PS_PERSON

Military Reserve Category

This is the military reserve category short description.

D_PERSON PS_D_PERSON MIL_RSRV_CAT_SD PS_PERSON

Military Grade Code This is a code that indicates the person's military grade.

D_PERSON PS_D_PERSON MIL_GRD_CD PS_PERSON

Home Email Id This is the home email address of a person.

D_PERSON PS_D_PERSON HOME_EMAIL_ID PS_PERSON

Military Separation Status Desc

This is the military separation status long description.

D_PERSON PS_D_PERSON MIL_SEP_STAT_LD PS_PERSON

Military Reserve Category Code

This is the military service reserve category code associated with the person.

D_PERSON PS_D_PERSON MIL_RSRV_CAT_CD PS_PERSON

Military Creditable Service Code

This is the creditable military service record associated with the person.

D_PERSON PS_D_PERSON MIL_CRED_SRVC_CD PS_PERSON

Marital Status Desc This is the marital status long description.

D_PERSON PS_D_PERSON MAR_STAT_LD PS_PERSON

Marital Status This is the marital status short description.

D_PERSON PS_D_PERSON MAR_STAT_SD PS_PERSON

Marital Status Code This is a code that indicates the marital status of a person.

D_PERSON PS_D_PERSON MAR_STAT_CD PS_PERSON

Work Email Id This is the work email address of a person.

D_PERSON PS_D_PERSON WORK_EMAIL_ID PS_PERSON

Cell Phone Number This is the cell phone number of a person.

D_PERSON PS_D_PERSON CELL_PHONE_NUM PS_PERSON

Monday, May 13, 2013 Page 26 of 47

Page 27: Campus Solutions Subject Area Dictionary · Presentation Table Presentation Column Presentation Description Logical Table Source ETL Logic and Logical Expression from Business Layer

CSW - Student Records - Term Enrollment

Presentation Table

Presentation Column Presentation Description Logical Table Source

ETL Logic and Logical Expression from Business Layer (if applicable)

Physical Table Physical Column PeopleSoft Table

Person

Work Phone Number This is the work phone number of a person.

D_PERSON PS_D_PERSON WORK_PHONE_NUM

PS_PERSON

Home Phone Number The home phone number. D_PERSON PS_D_PERSON HOME_PHONE_NUM

PS_PERSON

Military Separation Status

This is the military separation status short description.

D_PERSON PS_D_PERSON MIL_SEP_STAT_SD PS_PERSON

Other Email Id This is the alternate email address of a person.

D_PERSON PS_D_PERSON OTH_EMAIL_ID PS_PERSON

Veterans Preference Reduction in Force Indicator

This is a flag that indicates if the person is eligible for Veterans Preference in Reduction in Force (RIF).

D_PERSON PS_D_PERSON VET_PRFR_RIF_IND PS_PERSON

Ethnic Category Desc This is the long description of the ethnic category.

D_PERSON PS_D_ETHNIC_GRP ETHNIC_CTGRY_LD PS_ETHNIC_GRP_TBL

Employee High Potential Flag

Employee High Potential Flag D_PERSON

<edited>CASE WHEN ""Enterprise Warehouse""."""".""Enterprise Warehouse"".D_PERSON.HI_EDU_LVL_CD = 'J' OR 'K' OR 'L' THEN 'Y' ELSE 'N'

PS_D_PERSON HI_EDU_LVL_CD PS_PERSON

Person Name Drill The Person name with a drill to the OLTP feature.

Current Indicator The current row indicator. D_PERSON PS_D_PERSON CURRENT_IND

Home State Code This is the state code of the home address of a person.

D_PERSON PS_D_PERSON HOME_STATE_CD PS_PERSON

External Person Indicator

This is a flag that indicates if a person is external to the organization. This is used by Learning Management.

D_PERSON PS_D_PERSON EXT_PERSON_IND PS_PERSON

Monday, May 13, 2013 Page 27 of 47

Page 28: Campus Solutions Subject Area Dictionary · Presentation Table Presentation Column Presentation Description Logical Table Source ETL Logic and Logical Expression from Business Layer

CSW - Student Records - Term Enrollment

Presentation Table

Presentation Column Presentation Description Logical Table Source

ETL Logic and Logical Expression from Business Layer (if applicable)

Physical Table Physical Column PeopleSoft Table

Person

Home Country Code This is the country code of the home address of a person.

D_PERSON PS_D_PERSON HOME_CNTRY_CD PS_PERSON

Age Range This is the age classification of the employee.

Derived from BIRTHDATE field in PS_PERSON, with values of 'Below 20', '20-30', '31-50', 'Over 50' or 'N.A.'

Age Range This is the age classification of the employee.

Derived from BIRTHDATE field in PS_PERSON, with values of 'Below 20', '20-30', '31-50', 'Over 50' or 'N.A.'

Number Of Years Experience

This is the years of work experience of the person.

D_PERSON PS_D_PERSON EXP_YR_NUM PS_PERSON

Military Status Code This is the military status code of a person.

D_PERSON PS_D_PERSON MIL_STAT_CD PS_PERSON

Veterans Preference Code

This is the veterans preference code of a person.

D_PERSON PS_D_PERSON VET_PRFR_CD PS_PERSON

US Work Eligibility Indicator

This is a flag that indicates if the person is eligible to work in USA.

D_PERSON PS_D_PERSON US_WORK_ELIG_IND PS_PERSON

Preferred Communication Method Code

This is the preferred communication method of a person.

D_PERSON PS_D_PERSON PRFR_COMCN_MTHD_CD

PS_PERSON

Military Uniformed Service

This is the uniformed service code short description.

D_PERSON PS_D_PERSON MIL_COMP_SD PS_PERSON

Military Uniformed Service Desc

This is the uniformed service code long description.

D_PERSON PS_D_PERSON MIL_COMP_LD PS_PERSON

Military Uniformed Service Code

This is the uniformed service code of a person.

D_PERSON PS_D_PERSON MIL_COMP_CD PS_PERSON

Monday, May 13, 2013 Page 28 of 47

Page 29: Campus Solutions Subject Area Dictionary · Presentation Table Presentation Column Presentation Description Logical Table Source ETL Logic and Logical Expression from Business Layer

CSW - Student Records - Term Enrollment

Presentation Table

Presentation Column Presentation Description Logical Table Source

ETL Logic and Logical Expression from Business Layer (if applicable)

Physical Table Physical Column PeopleSoft Table

Person

Military Status This is the military status short description.

D_PERSON PS_D_PERSON MIL_STAT_SD PS_PERSON

Military Status Desc This is the military status long description.

D_PERSON PS_D_PERSON MIL_STAT_LD PS_PERSON

Age This is the age of the employee.

EXTRACT( YEAR FROM CURRENT_DATE ) - CAST ( LEFT( CAST ("Enterprise Warehouse"."Dimension Person"."Birth Date Sid" AS CHARACTER ( 10 )), 4) AS INTEGER )

Last Name This is the last name of a person. D_PERSON PS_D_PERSON LAST_NM PS_PERSON

Emergency Contact Name

This is the name of the emergency contact of the person.

D_PERSON PS_D_PERSON EMERG_CNTCT_NM PS_PERSON

Person Status Code This is the status of a person indicating if the person is an employee or an external customer employee. This is used by Learning Management.

D_PERSON PS_D_PERSON PERSON_STAT_CD PS_PERSON

Disabled Veteran Indicator

This is a flag that indicates if the person is a disabled veteran.

D_PERSON PS_D_PERSON DISABLED_VET_IND PS_PERSON

Disabled Indicator This is a flag that indicates if the person is disabled.

D_PERSON PS_D_PERSON DISABLED_IND PS_PERSON

Citizenship Proof Document 2

This is an alternate type of document for the proof of US citizenship of a person.

D_PERSON PS_D_PERSON CITZ_PROOF2_SD PS_PERSON

Citizenship Proof Document 1

This is one type of document for the proof of US citizenship of a person.

D_PERSON PS_D_PERSON CITZ_PROOF1_SD PS_PERSON

Monday, May 13, 2013 Page 29 of 47

Page 30: Campus Solutions Subject Area Dictionary · Presentation Table Presentation Column Presentation Description Logical Table Source ETL Logic and Logical Expression from Business Layer

CSW - Student Records - Term Enrollment

Presentation Table

Presentation Column Presentation Description Logical Table Source

ETL Logic and Logical Expression from Business Layer (if applicable)

Physical Table Physical Column PeopleSoft Table

Person

Death Date This is the date of death of a person.

Conformed to Date Dimension in ETL

PS_D_PERSON DT_OF_DEATH PS_PERSON

Emergency Phone Number

This is the phone number of the emergency contact of the person.

D_PERSON PS_D_PERSON EMERG_PHONE_NUM

PS_PERSON

Person Name This is the full name of a person. D_PERSON PS_D_PERSON PERSON_NM PS_PERSON

First Name This is the first name of a person. D_PERSON PS_D_PERSON FIRST_NM PS_PERSON

Middle Name This is the middle name of a person.

D_PERSON PS_D_PERSON MIDDLE_NM PS_PERSON

National Id This is the national identification number associated with a person.

D_PERSON PS_D_PERSON NTNL_ID PS_PERSON

Home Geography Code

This is the geography code of the home address of a person.

D_PERSON PS_D_PERSON HOME_GEO_CD PS_PERSON

Alternate Employee Id This is the alternate identification number for an employee.

D_PERSON PS_D_PERSON ALTER_EMPL_ID PS_PERSON

Performance Person Id

This is the performance person identifier that is mapped to a given person identifier.

D_PERSON PS_D_PERSON PF_PERSON_ID PS_PERSON

Person Id This is the identification number for an employee or non-employee of an organization that are of interest.

D_PERSON PS_D_PERSON PERSON_ID PS_PERSON

Source System Id The source system from where the data originated.

D_PERSON PS_D_PERSON SRC_SYS_ID PS_PERSON

Monday, May 13, 2013 Page 30 of 47

Page 31: Campus Solutions Subject Area Dictionary · Presentation Table Presentation Column Presentation Description Logical Table Source ETL Logic and Logical Expression from Business Layer

CSW - Student Records - Term Enrollment

Presentation Table

Presentation Column Presentation Description Logical Table Source

ETL Logic and Logical Expression from Business Layer (if applicable)

Physical Table Physical Column PeopleSoft Table

Person

Birth Date This is the date of birth of a person.

Conformed to Date Dimension in ETL

PS_D_PERSON BIRTHDATE PS_PERSON

Home Address Line 2 This is the address line 2 of the home address of a person.

D_PERSON PS_D_PERSON HOME_ADDR2_LD PS_PERSON

Employment Applicant Id

This is the employment applicant identification number associated with an employee.

D_PERSON PS_D_PERSON EMPLMNT_APP_ID PS_PERSON

Ethnic Group Code The code represents ethnic group to which the person belongs

D_PERSON PS_D_PERSON ETHNIC_GRP_CD PS_PERSON

Home Postal Code This is the postal code of the home address of a person.

D_PERSON PS_D_PERSON HOME_POSTAL_CD PS_PERSON

Ethnic Category D_PERSON PS_D_PERSON ETHNIC_CTGRY_SD PS_PERSON

Home City Name This is the city of the home address of a person.

D_PERSON PS_D_PERSON HOME_CITY_NM PS_PERSON

Home Address Line 3 This is the address line 3 of the home address of a person.

D_PERSON PS_D_PERSON HOME_ADDR3_LD PS_PERSON

Home Address Line 1 This is the address line 1 of the home address of a person.

D_PERSON PS_D_PERSON HOME_ADDR1_LD PS_PERSON

Highest Education Level Desc

This is the long description that indicates the highest education level of the person.

D_PERSON PS_D_PERSON HI_EDU_LVL_LD PS_PERSON

Highest Education Level

This is the short description that indicates the highest education level of the person.

D_PERSON PS_D_PERSON HI_EDU_LVL_SD PS_PERSON

Monday, May 13, 2013 Page 31 of 47

Page 32: Campus Solutions Subject Area Dictionary · Presentation Table Presentation Column Presentation Description Logical Table Source ETL Logic and Logical Expression from Business Layer

CSW - Student Records - Term Enrollment

Presentation Table

Presentation Column Presentation Description Logical Table Source

ETL Logic and Logical Expression from Business Layer (if applicable)

Physical Table Physical Column PeopleSoft Table

Person

Handicapped Indicator

This is a flag that indicates if the person is handicapped.

D_PERSON PS_D_PERSON HANDICAPPED_IND PS_PERSON

Ethnic Group Desc Long description for the ethnic group to which the person belongs

D_PERSON PS_D_PERSON ETHNIC_GRP_LD PS_PERSON

Home Address Line 4 This is the address line 4 of the home address of a person.

D_PERSON PS_D_PERSON HOME_ADDR4_LD PS_PERSON

Highest Education Level Code

This is a code that indicates the highest education level of the person.

D_PERSON PS_D_PERSON HI_EDU_LVL_CD PS_PERSON

Gender Code This is a code that indicates the gender of a person.

D_PERSON PS_D_PERSON GENDER_CD PS_PERSON

Ethnic Group Short description for the ethnic group to which the person belongs

D_PERSON PS_D_PERSON ETHNIC_GRP_SD PS_PERSON

Government Disability Code

This is the government disability code associated with the person.

D_PERSON PS_D_PERSON GOV_DISABILITY_CD PS_PERSON

Full-time Student Indicator

This is a flag that indicates if a person is a full time student.

D_PERSON PS_D_PERSON FULL_TM_STU_IND PS_PERSON

High Compensation Employee Indicator

This is a flag that indicates whether or not an employee is considered highly compensated according to U.S.

D_PERSON PS_D_PERSON HI_CMP_EMP_IND PS_PERSON

High Compensation Employee Plan Indicator

This is a flag that indicates whether or not the person is considered to be on a high compensation plan according to U.S.

D_PERSON PS_D_PERSON HI_CMP_EMP_PLN_IND

PS_PERSON

Monday, May 13, 2013 Page 32 of 47

Page 33: Campus Solutions Subject Area Dictionary · Presentation Table Presentation Column Presentation Description Logical Table Source ETL Logic and Logical Expression from Business Layer

CSW - Student Records - Term Enrollment

Presentation Table

Presentation Column Presentation Description Logical Table Source

ETL Logic and Logical Expression from Business Layer (if applicable)

Physical Table Physical Column PeopleSoft Table

Person

Person Address

City This is the City D_PERSON_ADDR PS_D_PERSON_ADDR CITY PS_ADDRESSES

Number1 This is the Number1 D_PERSON_ADDR PS_D_PERSON_ADDR NUM1 PS_ADDRESSES

This is the Number2 This is the Number2 D_PERSON_ADDR PS_D_PERSON_ADDR NUM2 PS_ADDRESSES

Address Line3 This is the Address3 D_PERSON_ADDR PS_D_PERSON_ADDR ADDRESS3 PS_ADDRESSES

House type This is the House type D_PERSON_ADDR PS_D_PERSON_ADDR HOUSE_TYPE PS_ADDRESSES

Address Line2 This is the Address2 D_PERSON_ADDR PS_D_PERSON_ADDR ADDRESS2 PS_ADDRESSES

Address Line4 This is the Address4 D_PERSON_ADDR PS_D_PERSON_ADDR ADDRESS4 PS_ADDRESSES

Address Line1 This is the Address1 D_PERSON_ADDR PS_D_PERSON_ADDR ADDRESS1 PS_ADDRESSES

Effective status This is Effective status D_PERSON_ADDR PS_D_PERSON_ADDR EFF_STATUS PS_ADDRESSES

Address field1 This is the Address field1 D_PERSON_ADDR PS_D_PERSON_ADDR ADDR_FIELD1 PS_ADDRESSES

Regulatory Region This is the Regulatory Region D_PERSON_ADDR PS_D_PERSON_ADDR REG_REGION PS_ADDRESSES

Source System Id This represents the Source System Identifier

D_PERSON_ADDR PS_D_PERSON_ADDR SRC_SYS_ID PS_ADDRESSES

Effective Date This is Effective Date D_PERSON_ADDR PS_D_PERSON_ADDR EFFDT PS_ADDRESSES

Address type This is the Address types D_PERSON_ADDR PS_D_PERSON_ADDR ADDRESS_TYPE PS_ADDRESSES

Country This is the Country D_PERSON_ADDR PS_D_PERSON_ADDR COUNTRY PS_ADDRESSES

Alternate Character Address1

This is Alternate Character Address1

D_PERSON_ADDR PS_D_PERSON_ADDR ADDRESS1_AC PS_ADDRESSES

Address Preference Flag

This is Address Preference Flag D_PERSON_ADDR PS_D_PERSON_ADDR CSW_ADDR_PREF_FLG

PS_ADDRESSES

Current Indicator This is Current Indicator D_PERSON_ADDR PS_D_PERSON_ADDR CURRENT_IND

Monday, May 13, 2013 Page 33 of 47

Page 34: Campus Solutions Subject Area Dictionary · Presentation Table Presentation Column Presentation Description Logical Table Source ETL Logic and Logical Expression from Business Layer

CSW - Student Records - Term Enrollment

Presentation Table

Presentation Column Presentation Description Logical Table Source

ETL Logic and Logical Expression from Business Layer (if applicable)

Physical Table Physical Column PeopleSoft Table

Person Address

Employee Id This is Employee Id D_PERSON_ADDR PS_D_PERSON_ADDR EMPLID PS_ADDRESSES

Last Update Oprid This is the Last Update Oprid D_PERSON_ADDR PS_D_PERSON_ADDR LASTUPDOPRID PS_ADDRESSES

Last Update Date/Time

This is the Last Update Date/Time D_PERSON_ADDR PS_D_PERSON_ADDR LASTUPDDTTM PS_ADDRESSES

Alternate Character Address3

This is Alternate Character Address3

D_PERSON_ADDR PS_D_PERSON_ADDR ADDRESS3_AC PS_ADDRESSES

Alternate Character Address2

This is Alternate Character Address2

D_PERSON_ADDR PS_D_PERSON_ADDR ADDRESS2_AC PS_ADDRESSES

Address field2 This is the Address field2 D_PERSON_ADDR PS_D_PERSON_ADDR ADDR_FIELD2 PS_ADDRESSES

In City Limit This is the In City Limit D_PERSON_ADDR PS_D_PERSON_ADDR IN_CITY_LIMIT PS_ADDRESSES

Geographic code This is the Geographic code D_PERSON_ADDR PS_D_PERSON_ADDR GEO_CODE PS_ADDRESSES

Postal Code This is the Postal Code D_PERSON_ADDR PS_D_PERSON_ADDR POSTAL PS_ADDRESSES

State This is the State D_PERSON_ADDR PS_D_PERSON_ADDR STATE PS_ADDRESSES

County This is the County D_PERSON_ADDR PS_D_PERSON_ADDR COUNTY PS_ADDRESSES

Address field3 This is the Address field3 D_PERSON_ADDR PS_D_PERSON_ADDR ADDR_FIELD3 PS_ADDRESSES

Alternate Character City

This is the Alternate Character City

D_PERSON_ADDR PS_D_PERSON_ADDR CITY_AC PS_ADDRESSES

Person Attribute

Official Residence The Residency Type to find whether the student is In State or Out of State etc.

D_PERSON_ATTR PS_D_PERSON_ATTR OFF_RESIDENCY PS_RESIDENCY_OFF

Person Id This is the code that identifies the person.

D_PERSON_ATTR PS_D_PERSON_ATTR PERSON_ID PS_PERSON

Monday, May 13, 2013 Page 34 of 47

Page 35: Campus Solutions Subject Area Dictionary · Presentation Table Presentation Column Presentation Description Logical Table Source ETL Logic and Logical Expression from Business Layer

CSW - Student Records - Term Enrollment

Presentation Table

Presentation Column Presentation Description Logical Table Source

ETL Logic and Logical Expression from Business Layer (if applicable)

Physical Table Physical Column PeopleSoft Table

Person Attribute

Official Country Of Residence

The Official Country Of Residence.

D_PERSON_ATTR PS_D_PERSON_ATTR OFF_COUNTRY PS_RESIDENCY_OFF

Official State Of Residence

The Official State Of Residence. D_PERSON_ATTR PS_D_PERSON_ATTR OFF_STATE PS_RESIDENCY_OFF

Official County Of Residence

The Official County Of Residence. D_PERSON_ATTR PS_D_PERSON_ATTR OFF_COUNTY PS_RESIDENCY_OFF

Official City Of Residence

The Official City Of Residence. D_PERSON_ATTR PS_D_PERSON_ATTR OFF_CITY PS_RESIDENCY_OFF

Official Residence Description

Description of the Official residence.

D_PERSON_ATTR PS_D_PERSON_ATTR OFF_RESIDENCY_DESC

PS_RESIDENCY_TBL

Student Campus ID The Student Campus ID. D_PERSON_ATTR PS_D_PERSON_ATTR STDNT_CAMPUS_ID PS_PERSON_SA

Athlete Flag Flag to denote the student is an Athlete.

D_PERSON_ATTR PS_D_PERSON_ATTR ATHLETE_FLAG PS_ATHL_PART_STAT

Visa Workpermit Status

Work Permit Status of the Visa. D_PERSON_ATTR PS_D_PERSON_ATTR VISA_WRKPMT_STATUS

PS_VISA_PMT_DATA

Visa Permit Type Description

Description of the Visa Permit Type

D_PERSON_ATTR PS_D_PERSON_ATTR VISA_PERMT_TY_DESC

PS_VISA_PERMIT_TBL

Visa Permit Type The Visa Permit Type D_PERSON_ATTR PS_D_PERSON_ATTR VISA_PERMIT_TYPE PS_VISA_PMT_DATA

Visa Effective Date The date from which the Visa is effective from

D_PERSON_ATTR PS_D_PERSON_ATTR VISA_EFFDT PS_VISA_PMT_DATA

Citizenship Status This is the short description for the citizenship status.

D_PERSON_ATTR PS_D_PERSON_ATTR CITZ_STAT_SD PS_CITIZEN_STS_TBL

Official Residency Date

The Official Residency Date. D_PERSON_ATTR PS_D_PERSON_ATTR OFF_RESIDENCY_DT PS_RESIDENCY_OFF

Current Indicator The current row indicator. D_PERSON_ATTR PS_D_PERSON_ATTR CURRENT_IND

Monday, May 13, 2013 Page 35 of 47

Page 36: Campus Solutions Subject Area Dictionary · Presentation Table Presentation Column Presentation Description Logical Table Source ETL Logic and Logical Expression from Business Layer

CSW - Student Records - Term Enrollment

Presentation Table

Presentation Column Presentation Description Logical Table Source

ETL Logic and Logical Expression from Business Layer (if applicable)

Physical Table Physical Column PeopleSoft Table

Person Attribute

Source System Id The source system from where the data originated.

D_PERSON_ATTR PS_D_PERSON_ATTR SRC_SYS_ID PS_PERSON

Citizenship Status Code

This is the code that identifies the citizenship status.

D_PERSON_ATTR PS_D_PERSON_ATTR CITZ_STAT_CD PS_CITIZEN_STS_TBL

Citizenship Status Desc

This is the long description for the citizenship status.

D_PERSON_ATTR PS_D_PERSON_ATTR CITZ_STAT_LD PS_CITIZEN_STS_TBL

Citizenship Country Code

This is the code that identifies the citizenship country.

D_PERSON_ATTR PS_D_PERSON_ATTR CITZ_CNTRY_CD PS_CITIZENSHIP

Citizenship Country This is the short description for the citizenship country.

D_PERSON_ATTR PS_D_PERSON_ATTR CITZ_CNTRY_SD PS_COUNTRY_TBL

Citizenship Country Desc

This is the long description for the citizenship country.

D_PERSON_ATTR PS_D_PERSON_ATTR CITZ_CNTRY_LD PS_COUNTRY_TBL

FERPA Flag This is the FERPA flag for the student.

D_PERSON_ATTR PS_D_PERSON_ATTR FERPA_FLG PS_PERSON_SA

Person Email

Dormitory Email Address

This represents the Dormitory Email Address

D_PERSON_EMAIL PS_D_PERSON_EMAIL DORM_EMAIL PS_EMAIL_ADDRESSES

Other Email Address This represents the Other Email Address

D_PERSON_EMAIL PS_D_PERSON_EMAIL OTHER_EMAIL PS_EMAIL_ADDRESSES

Preferred Email Type This represents the Preferred Email Type

D_PERSON_EMAIL PS_D_PERSON_EMAIL PREF_EMAIL_TYPE_LD

PS_EMAIL_ADDRESSES

Home Email Address This represents the Home Email Address

D_PERSON_EMAIL PS_D_PERSON_EMAIL HOME_EMAIL PS_EMAIL_ADDRESSES

Preferred Email Type Short Description

This represents the Preferred Email Type Short Description

D_PERSON_EMAIL PS_D_PERSON_EMAIL PREF_EMAIL_TYPE_SD

PS_EMAIL_ADDRESSES

Monday, May 13, 2013 Page 36 of 47

Page 37: Campus Solutions Subject Area Dictionary · Presentation Table Presentation Column Presentation Description Logical Table Source ETL Logic and Logical Expression from Business Layer

CSW - Student Records - Term Enrollment

Presentation Table

Presentation Column Presentation Description Logical Table Source

ETL Logic and Logical Expression from Business Layer (if applicable)

Physical Table Physical Column PeopleSoft Table

Person Email

Business Email Address

This represents the Business Email Address

D_PERSON_EMAIL PS_D_PERSON_EMAIL BUSINESS_EMAIL PS_EMAIL_ADDRESSES

Preferred Email Address

This represents the Preferred Email Address

D_PERSON_EMAIL PS_D_PERSON_EMAIL PREF_EMAIL PS_EMAIL_ADDRESSES

Person Id This represents the Person ID D_PERSON_EMAIL PS_D_PERSON_EMAIL PERSON_ID PS_EMAIL_ADDRESSES

Current Indicator This represents the Current Indicator

D_PERSON_EMAIL PS_D_PERSON_EMAIL CURRENT_IND

Campus Email Address

This represents the Campus Email Address

D_PERSON_EMAIL PS_D_PERSON_EMAIL CAMPUS_EMAIL PS_EMAIL_ADDRESSES

Source System Id This represents the Source System Identifier

D_PERSON_EMAIL PS_D_PERSON_EMAIL SRC_SYS_ID PS_EMAIL_ADDRESSES

Person Phone

Current Indicator This represents the Current Indicator

D_PERSON_PHONE PS_D_PERSON_PHONE CURRENT_IND

Preferred Phone Type Short Description

This represents the Preferred Phone Type Short Description

D_PERSON_PHONE PS_D_PERSON_PHONE PREF_PHONE_TYPE_SD

PS_PERSONAL_PHONE

Preferred Phone Type This represents the Preferred Phone Type

D_PERSON_PHONE PS_D_PERSON_PHONE PREF_PHONE_TYPE_LD

PS_PERSONAL_PHONE

Preferred Extension Number

This represents the Preferred Extension Number

D_PERSON_PHONE PS_D_PERSON_PHONE PREF_EXT PS_PERSONAL_PHONE

Pager1 Extension Number

This represents the Pager1 Extension Number

D_PERSON_PHONE PS_D_PERSON_PHONE PGR1_EXT PS_PERSONAL_PHONE

Preferred Country Code

This represents the Preferred Country Code

D_PERSON_PHONE PS_D_PERSON_PHONE PREF_CTRY_CODE PS_PERSONAL_PHONE

Monday, May 13, 2013 Page 37 of 47

Page 38: Campus Solutions Subject Area Dictionary · Presentation Table Presentation Column Presentation Description Logical Table Source ETL Logic and Logical Expression from Business Layer

CSW - Student Records - Term Enrollment

Presentation Table

Presentation Column Presentation Description Logical Table Source

ETL Logic and Logical Expression from Business Layer (if applicable)

Physical Table Physical Column PeopleSoft Table

Person Phone

Campus Extension Number

This represents the Campus Extension Number

D_PERSON_PHONE PS_D_PERSON_PHONE CAMP_EXT PS_PERSONAL_PHONE

Dormitory Extension Number

This represents the Dormitory Extension Number

D_PERSON_PHONE PS_D_PERSON_PHONE DORM_EXT PS_PERSONAL_PHONE

Pager1 Phone Number

This represents the Pager1 Phone Number

D_PERSON_PHONE PS_D_PERSON_PHONE PGR1_PHONE PS_PERSONAL_PHONE

Dormitory Country Code

This represents the Dormitory Country Code

D_PERSON_PHONE PS_D_PERSON_PHONE DORM_CTRY_CODE PS_PERSONAL_PHONE

Preferred Phone Number

This represents the Preferred Phone Number

D_PERSON_PHONE PS_D_PERSON_PHONE PREF_PHONE PS_PERSONAL_PHONE

Main Phone Number This represents the Main Phone Number

D_PERSON_PHONE PS_D_PERSON_PHONE MAIN_PHONE PS_PERSONAL_PHONE

Main Country Code This represents the Main Country Code

D_PERSON_PHONE PS_D_PERSON_PHONE MAIN_CTRY_CODE PS_PERSONAL_PHONE

Other Extension Number

This represents the Other Extension Number

D_PERSON_PHONE PS_D_PERSON_PHONE OTR_EXT PS_PERSONAL_PHONE

Cell Country Code This represents the Cell Country Code

D_PERSON_PHONE PS_D_PERSON_PHONE CELL_CTRY_CODE PS_PERSONAL_PHONE

Other Country Code This represents the Other Country Code

D_PERSON_PHONE PS_D_PERSON_PHONE OTR_CTRY_CODE PS_PERSONAL_PHONE

Dormitory Phone Number

This represents the Dormitory Phone Number

D_PERSON_PHONE PS_D_PERSON_PHONE DORM_PHONE PS_PERSONAL_PHONE

Campus Phone Number

This represents the Campus Phone Number

D_PERSON_PHONE PS_D_PERSON_PHONE CAMP_PHONE PS_PERSONAL_PHONE

Campus Country Code This represents the Campus Country Code

D_PERSON_PHONE PS_D_PERSON_PHONE CAMP_CTRY_CODE PS_PERSONAL_PHONE

Monday, May 13, 2013 Page 38 of 47

Page 39: Campus Solutions Subject Area Dictionary · Presentation Table Presentation Column Presentation Description Logical Table Source ETL Logic and Logical Expression from Business Layer

CSW - Student Records - Term Enrollment

Presentation Table

Presentation Column Presentation Description Logical Table Source

ETL Logic and Logical Expression from Business Layer (if applicable)

Physical Table Physical Column PeopleSoft Table

Person Phone

Home Extension Number

This represents the Home Extension Number

D_PERSON_PHONE PS_D_PERSON_PHONE HOME_EXT PS_PERSONAL_PHONE

Home Phone Number This represents the Home Phone Number

D_PERSON_PHONE PS_D_PERSON_PHONE HOME_PHONE PS_PERSONAL_PHONE

Home Country Code This represents the Home Country Code

D_PERSON_PHONE PS_D_PERSON_PHONE HOME_CTRY_CODE PS_PERSONAL_PHONE

Source System Id This represents the Source System Identifier

D_PERSON_PHONE PS_D_PERSON_PHONE SRC_SYS_ID PS_PERSONAL_PHONE

Person Id This represents the Person ID D_PERSON_PHONE PS_D_PERSON_PHONE PERSON_ID PS_PERSONAL_PHONE

Other Phone Number This represents the Other Phone Number

D_PERSON_PHONE PS_D_PERSON_PHONE OTR_PHONE PS_PERSONAL_PHONE

Telex Country Code This represents the Telex Country Code

D_PERSON_PHONE PS_D_PERSON_PHONE TELX_CTRY_CODE PS_PERSONAL_PHONE

Pager1 Country Code This represents the Pager1 Country Code

D_PERSON_PHONE PS_D_PERSON_PHONE PGR1_CTRY_CODE PS_PERSONAL_PHONE

Pager2 Extension Number

This represents the Pager2 Extension Number

D_PERSON_PHONE PS_D_PERSON_PHONE PGR2_EXT PS_PERSONAL_PHONE

Pager2 Phone Number

This represents the Pager2 Phone Number

D_PERSON_PHONE PS_D_PERSON_PHONE PGR2_PHONE PS_PERSONAL_PHONE

Pager2 Country Code This represents the Pager2 Country Code

D_PERSON_PHONE PS_D_PERSON_PHONE PGR2_CTRY_CODE PS_PERSONAL_PHONE

Main Extension Number

This represents the Main Extension Number

D_PERSON_PHONE PS_D_PERSON_PHONE MAIN_EXT PS_PERSONAL_PHONE

Telex Phone Number This represents the Telex Phone Number

D_PERSON_PHONE PS_D_PERSON_PHONE TELX_PHONE PS_PERSONAL_PHONE

Monday, May 13, 2013 Page 39 of 47

Page 40: Campus Solutions Subject Area Dictionary · Presentation Table Presentation Column Presentation Description Logical Table Source ETL Logic and Logical Expression from Business Layer

CSW - Student Records - Term Enrollment

Presentation Table

Presentation Column Presentation Description Logical Table Source

ETL Logic and Logical Expression from Business Layer (if applicable)

Physical Table Physical Column PeopleSoft Table

Person Phone

Cell Phone Number This represents the Cell Phone Number

D_PERSON_PHONE PS_D_PERSON_PHONE CELL_PHONE PS_PERSONAL_PHONE

Business Extension Number

This represents the Business Extension Number

D_PERSON_PHONE PS_D_PERSON_PHONE BUSN_EXT PS_PERSONAL_PHONE

Fax Country Code This represents the Fax Country Code

D_PERSON_PHONE PS_D_PERSON_PHONE FAX_CTRY_CODE PS_PERSONAL_PHONE

Telex Extension Number

This represents the Telex Extension Number

D_PERSON_PHONE PS_D_PERSON_PHONE TELX_EXT PS_PERSONAL_PHONE

Cell Extension Number

This represents the Cell Extension Number

D_PERSON_PHONE PS_D_PERSON_PHONE CELL_EXT PS_PERSONAL_PHONE

Business Phone Number

This represents the Business Phone Number

D_PERSON_PHONE PS_D_PERSON_PHONE BUSN_PHONE PS_PERSONAL_PHONE

Fax Phone Number This represents the Fax Phone Number

D_PERSON_PHONE PS_D_PERSON_PHONE FAX_PHONE PS_PERSONAL_PHONE

Fax Extension This represents the Fax Extension Number

D_PERSON_PHONE PS_D_PERSON_PHONE FAX_EXT PS_PERSONAL_PHONE

Work Country Code This represents the Work Country Code

D_PERSON_PHONE PS_D_PERSON_PHONE WORK_CTRY_CODE PS_PERSONAL_PHONE

Work Phone Number This represents the Work Phone Number

D_PERSON_PHONE PS_D_PERSON_PHONE WORK_PHONE PS_PERSONAL_PHONE

Work Extension Number

This represents the Work Extension Number

D_PERSON_PHONE PS_D_PERSON_PHONE WORK_EXT PS_PERSONAL_PHONE

Business Country Code

This represents the Business Country Code

D_PERSON_PHONE PS_D_PERSON_PHONE BUSN_CTRY_CODE PS_PERSONAL_PHONE

Program Action

Monday, May 13, 2013 Page 40 of 47

Page 41: Campus Solutions Subject Area Dictionary · Presentation Table Presentation Column Presentation Description Logical Table Source ETL Logic and Logical Expression from Business Layer

CSW - Student Records - Term Enrollment

Presentation Table

Presentation Column Presentation Description Logical Table Source

ETL Logic and Logical Expression from Business Layer (if applicable)

Physical Table Physical Column PeopleSoft Table

Program Action

Program Action Code This is the code that identifies an academic program action.

D_PROG_ACN PS_D_PROG_ACN PROG_ACN_CD PS_PROG_ACTION_TBL

Program Action This is the short description that identifies an academic program action.

D_PROG_ACN PS_D_PROG_ACN PROG_ACN_SD PS_PROG_ACTION_TBL

Program Action Desc This is the long description that identifies an academic program action.

D_PROG_ACN PS_D_PROG_ACN PROG_ACN_LD PS_PROG_ACTION_TBL

Current Indicator The current row indicator. D_PROG_ACN PS_D_PROG_ACN CURRENT_IND

Source System Id The source system from where the data originated.

D_PROG_ACN PS_D_PROG_ACN SRC_SYS_ID PS_PROG_ACTION_TBL

Program Action Reason

Program Action Reason

This is the short description that identifies an academic program action reason.

D_PROG_ACN_RSN PS_D_PROG_ACN_RSN PROG_ACN_RSN_SD PS_PROG_RSN_TBL

Source Setid This is the source setid associated to the program action reason.

D_PROG_ACN_RSN PS_D_PROG_ACN_RSN SRC_SETID PS_PROG_RSN_TBL

Source System Id The source system from where the data originated.

D_PROG_ACN_RSN PS_D_PROG_ACN_RSN SRC_SYS_ID PS_PROG_RSN_TBL

Program Action Code This is the code that identifies an academic program action.

D_PROG_ACN_RSN PS_D_PROG_ACN_RSN PROG_ACN_CD PS_PROG_RSN_TBL

Program Action This is the short description that identifies an academic program action.

D_PROG_ACN_RSN PS_D_PROG_ACN_RSN PROG_ACN_SD PS_PROG_RSN_TBL

Monday, May 13, 2013 Page 41 of 47

Page 42: Campus Solutions Subject Area Dictionary · Presentation Table Presentation Column Presentation Description Logical Table Source ETL Logic and Logical Expression from Business Layer

CSW - Student Records - Term Enrollment

Presentation Table

Presentation Column Presentation Description Logical Table Source

ETL Logic and Logical Expression from Business Layer (if applicable)

Physical Table Physical Column PeopleSoft Table

Program Action Reason

Program Action Reason Code

This is the code that identifies an academic program action reason.

D_PROG_ACN_RSN PS_D_PROG_ACN_RSN PROG_ACN_RSN_CD PS_PROG_RSN_TBL

Program Action Reason Desc

This is the long description that identifies an academic program action reason.

D_PROG_ACN_RSN PS_D_PROG_ACN_RSN PROG_ACN_RSN_LD PS_PROG_RSN_TBL

Current Indicator The current row indicator. D_PROG_ACN_RSN PS_D_PROG_ACN_RSN CURRENT_IND

Setid This is the setid associated to the program action reason.

D_PROG_ACN_RSN PS_D_PROG_ACN_RSN SETID PS_PROG_RSN_TBL

Program Action Desc This is the long description that identifies an academic program action.

D_PROG_ACN_RSN PS_D_PROG_ACN_RSN PROG_ACN_LD PS_PROG_RSN_TBL

Program Status

Program Status Code This is the code that identifies an academic program status.

D_PROG_STAT PS_D_PROG_STAT PROG_STAT_CD PSXLATITEM

Current Indicator The current row indicator. D_PROG_STAT PS_D_PROG_STAT CURRENT_IND

Program Status This is the short description that identifies an academic program status.

D_PROG_STAT PS_D_PROG_STAT PROG_STAT_SD PSXLATITEM

Source System Id The source system from where the data originated.

D_PROG_STAT PS_D_PROG_STAT SRC_SYS_ID PSXLATITEM

Program Status Desc This is the long description that identifies an academic program status.

D_PROG_STAT PS_D_PROG_STAT PROG_STAT_LD PSXLATITEM

Student Career Number

Monday, May 13, 2013 Page 42 of 47

Page 43: Campus Solutions Subject Area Dictionary · Presentation Table Presentation Column Presentation Description Logical Table Source ETL Logic and Logical Expression from Business Layer

CSW - Student Records - Term Enrollment

Presentation Table

Presentation Column Presentation Description Logical Table Source

ETL Logic and Logical Expression from Business Layer (if applicable)

Physical Table Physical Column PeopleSoft Table

Student Career Number

Student Career Number

This is the number that indicates the student career.

F_TERM_ENRLMT PS_F_TERM_ENRLMT STDNT_CAR_NUM PS_STDNT_CAR_TERM, PS_TERM_TBL

Student Cohort

Institution Code This is the code that identifies an academic institution.

D_STDNT_COHORT PS_D_STDNT_COHORT INSTITUTION_CD PS_STDNT_ATTR_VAL

Source System Id The source system from where the data originated.

R_STDNT_COHORT PS_R_STDNT_COHORT SRC_SYS_ID PS_STDNT_ATTR_DTL

Current Indicator The current row indicator. D_STDNT_COHORT PS_D_STDNT_COHORT CURRENT_IND

Attribute Value Primacy Number

This is the number that identifies the primacy attribute value for a student.

D_STDNT_COHORT PS_D_STDNT_COHORT ATTR_VAL_PRIM_NUM

PS_STDNT_ATTR_VAL

Institution Desc This is the long description that identifies an academic institution.

D_STDNT_COHORT PS_D_STDNT_COHORT INSTITUTION_LD PS_STDNT_ATTR_VAL

Institution This is the short description that identifies an academic institution.

D_STDNT_COHORT PS_D_STDNT_COHORT INSTITUTION_SD PS_STDNT_ATTR_VAL

Student Attribute Value Desc

This is the long description that identifies a student attribute value.

D_STDNT_COHORT PS_D_STDNT_COHORT STDNT_ATTR_VAL_LD

PS_STDNT_ATTR_VAL

Student Attribute Value

This is the short description that identifies a student attribute value.

D_STDNT_COHORT PS_D_STDNT_COHORT STDNT_ATTR_VAL_SD

PS_STDNT_ATTR_VAL

Student Attribute Value Code

This is the code that identifies a student attribute value.

D_STDNT_COHORT PS_D_STDNT_COHORT STDNT_ATTR_VAL_CD

PS_STDNT_ATTR_VAL

Monday, May 13, 2013 Page 43 of 47

Page 44: Campus Solutions Subject Area Dictionary · Presentation Table Presentation Column Presentation Description Logical Table Source ETL Logic and Logical Expression from Business Layer

CSW - Student Records - Term Enrollment

Presentation Table

Presentation Column Presentation Description Logical Table Source

ETL Logic and Logical Expression from Business Layer (if applicable)

Physical Table Physical Column PeopleSoft Table

Student Cohort

Student Attribute Desc

This is the long description that identifies a student attribute.

D_STDNT_COHORT PS_D_STDNT_COHORT STDNT_ATTR_LD PS_STDNT_ATTR_VAL

Student Attribute This is the short description that identifies a student attribute.

D_STDNT_COHORT PS_D_STDNT_COHORT STDNT_ATTR_SD PS_STDNT_ATTR_VAL

Source System Id The source system from where the data originated.

D_STDNT_COHORT PS_D_STDNT_COHORT SRC_SYS_ID PS_STDNT_ATTR_VAL

Student Attribute Code

This is the code that identifies a student attribute.

D_STDNT_COHORT PS_D_STDNT_COHORT STDNT_ATTR_CD PS_STDNT_ATTR_VAL

Student Group

Current Indicator The current row indicator. D_STDNT_GRP PS_D_STDNT_GRP CURRENT_IND

Institution Code This is the code that identifies an academic institution.

D_STDNT_GRP PS_D_STDNT_GRP INSTITUTION_CD PS_STDNT_GROUP_TBL

Institution This is the short description that identifies an academic institution.

D_STDNT_GRP PS_D_STDNT_GRP INSTITUTION_SD PS_STDNT_GROUP_TBL

Student Group This is the short description that identifies a student group.

D_STDNT_GRP PS_D_STDNT_GRP STDNT_GRP_SD PS_STDNT_GROUP_TBL

Student Group Code This is the code that identified the student group.

D_STDNT_GRP PS_D_STDNT_GRP STDNT_GRP_CD PS_STDNT_GROUP_TBL

Source System Id The source system from where the data originated.

D_STDNT_GRP PS_D_STDNT_GRP SRC_SYS_ID PS_STDNT_GROUP_TBL

Source System Id The source system from where the data originated.

R_STDNT_GRP PS_R_STDNT_GRP SRC_SYS_ID PS_STDNT_GRPS_HIST

Monday, May 13, 2013 Page 44 of 47

Page 45: Campus Solutions Subject Area Dictionary · Presentation Table Presentation Column Presentation Description Logical Table Source ETL Logic and Logical Expression from Business Layer

CSW - Student Records - Term Enrollment

Presentation Table

Presentation Column Presentation Description Logical Table Source

ETL Logic and Logical Expression from Business Layer (if applicable)

Physical Table Physical Column PeopleSoft Table

Student Group

Institution Desc This is the long description that identifies an academic institution.

D_STDNT_GRP PS_D_STDNT_GRP INSTITUTION_LD PS_STDNT_GROUP_TBL

Student Group Desc This is the long description that identifies a student group.

D_STDNT_GRP PS_D_STDNT_GRP STDNT_GRP_LD PS_STDNT_GROUP_TBL

Term

Instruction Weeks This is the number of instruction week in a term

D_TERM PS_D_TERM INSTRCTN_WEEK_NUM

PS_TERM_TBL

Term Category This is the short description that identifies a term category.

D_TERM PS_D_TERM TERM_CTGRY_SD PS_TERM_TBL

Holiday Schedule Code

This is the code that identifies the holiday schedule for a given term.

D_TERM PS_D_TERM HOLIDAY_SCHED_CD PS_TERM_TBL

Holiday Schedule This is the short description of the holiday schedule for a given term.

D_TERM PS_D_TERM HOLIDAY_SCHED_SD PS_TERM_TBL

Holiday Schedule This is the long description of the holiday schedule for a given term.

D_TERM PS_D_TERM HOLIDAY_SCHED_LD PS_TERM_TBL

Term End Date This is the date on which the term ends.

D_TERM PS_D_TERM TERM_END_DT PS_TERM_TBL

Term Category Code This is the code that identifies a term category.

D_TERM PS_D_TERM TERM_CTGRY_CD PS_TERM_TBL

Sixty Percentage Date This is the date that shows the sixty percent point in time.

D_TERM PS_D_TERM SIXTY_PCT_DT PS_TERM_TBL

Monday, May 13, 2013 Page 45 of 47

Page 46: Campus Solutions Subject Area Dictionary · Presentation Table Presentation Column Presentation Description Logical Table Source ETL Logic and Logical Expression from Business Layer

CSW - Student Records - Term Enrollment

Presentation Table

Presentation Column Presentation Description Logical Table Source

ETL Logic and Logical Expression from Business Layer (if applicable)

Physical Table Physical Column PeopleSoft Table

Term

Current Indicator The current row indicator. D_TERM PS_D_TERM CURRENT_IND

Term Begin Date This is the date on which the term begins.

D_TERM PS_D_TERM TERM_BEGIN_DT PS_TERM_TBL

Term Code This is the code that identifies an academic term.

D_TERM PS_D_TERM TERM_CD PS_TERM_TBL

Term Category Desc This is the long description that identifies a term category.

D_TERM PS_D_TERM TERM_CTGRY_LD PS_TERM_TBL

Source System Id The source system from where the data originated.

D_TERM PS_D_TERM SRC_SYS_ID PS_TERM_TBL

Institution Desc This is the long description that identifies an academic institution.

D_TERM PS_D_TERM INSTITUTION_LD PS_TERM_TBL

Term This is the short description that identifies an academic term.

D_TERM PS_D_TERM TERM_SD PS_TERM_TBL

Term Desc This is the long description that identifies an academic term.

D_TERM PS_D_TERM TERM_LD PS_TERM_TBL

Academic Career Code

This is the code that identifies an academic career.

D_TERM PS_D_TERM ACAD_CAR_CD PS_TERM_TBL

Academic Career This is the short description of the academic career.

D_TERM PS_D_TERM ACAD_CAR_SD PS_TERM_TBL

Academic Career Desc This is the long description that identifies an academic career.

D_TERM PS_D_TERM ACAD_CAR_LD PS_TERM_TBL

Institution Code This is the code that identifies an academic institution.

D_TERM PS_D_TERM INSTITUTION_CD PS_TERM_TBL

Monday, May 13, 2013 Page 46 of 47

Page 47: Campus Solutions Subject Area Dictionary · Presentation Table Presentation Column Presentation Description Logical Table Source ETL Logic and Logical Expression from Business Layer

CSW - Student Records - Term Enrollment

Presentation Table

Presentation Column Presentation Description Logical Table Source

ETL Logic and Logical Expression from Business Layer (if applicable)

Physical Table Physical Column PeopleSoft Table

Term

Institution This is the short description that identifies an academic institution.

D_TERM PS_D_TERM INSTITUTION_SD PS_TERM_TBL

Academic Year This is the academic year. D_TERM PS_D_TERM ACAD_YR_SID PS_TERM_TBL

Term Residency

Source System Id The source system from where the data originated.

D_TERM_RSDNCY PS_D_RSDNCY SRC_SYS_ID PS_RESIDENCY_TBL

Residency Id This is the residency code. D_TERM_RSDNCY PS_D_RSDNCY RSDNCY_ID PS_RESIDENCY_TBL

Residency This is the residency short description.

D_TERM_RSDNCY PS_D_RSDNCY RSDNCY_SD PS_RESIDENCY_TBL

Residency Desc This is the residency long description.

D_TERM_RSDNCY PS_D_RSDNCY RSDNCY_LD PS_RESIDENCY_TBL

Current Indicator The current row indicator. D_TERM_RSDNCY PS_D_RSDNCY CURRENT_IND

Year Academic

Academic Year Number

The year number. D_YEAR_Academic PS_D_YEAR YEAR_NUM

Academic Year Desc This is the description of the year.

D_YEAR_Academic PS_D_YEAR YEAR_DESCR

Monday, May 13, 2013 Page 47 of 47