campus solutions subject area dictionary · presentation table presentation column presentation...
TRANSCRIPT
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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