UM_D_PERSCHK_VW - Person Checklist

This View was built for the Discoverer Tool which has been retired,  The view remains valid and is available for use. 
It includes Student "To Do" Checklist definition and setup details.

Detailed Information

Databases

PeopleSoft Campus Solutions CSPRD 
PeopleSoft Campus Solutions Reporting CSRPT

Source Tables

PERSON_CHECKLST - Person Checklist
CS_CHKLST_TBL - CS Checklist Codes

View SQL Code
Download SQL Code

Key Record.Fieldname Format XLAT Heading Text Source Tables
  ADMIN_FUNCTION - Administrative Function Char4   Function PERSON_CHECKLST
  CHECKLIST_CD - Checklist Code Char6   Checklist PERSON_CHECKLST
  CHECKLIST_DTTM - Checklist Date Time DateTm   DateTime PERSON_CHECKLST
  CHECKLIST_STATUS - Checklist Status Char1 N Status PERSON_CHECKLST
  COMM_COMMENTS - Comments Text   Comment PERSON_CHECKLST
Key COMMON_ID - ID Char11   ID PERSON_CHECKLST
  CONTACT_NAME - Contact Name Char50   Name PERSON_CHECKLST
  CURRENCY_CD - Currency Code Char3   Currency PERSON_CHECKLIT
  DEPTID - Department Char10   DeptID PERSON_CHECKLST
  DUE_AMT - Due Amount SNm14.2   Due Amt PERSON_CHECKLST
  DUE_DT - Due Date Date   Due Date PERSON_CHECKLST
  INSTITUTION - Academic Institution Char5   Institution PERSON_CHECKLST
  ORG_CONTACT - Contact Nbr Num4.0   Contact PERSON_CHECKLST
  RESPONSIBLE_ID - Responsible ID Char11   Resp ID PERSON_CHECKLST
  SA_ID_TYPE - ID Type Char1 N ID Type PERSON_CHECKLST
Key SEQ_3C - Sequence Number Num5.0   Sequence PERSON_CHECKLST
  STATUS_CHANGE_ID - Status Change ID Char11   Change ID PERSON_CHECKLST
  STATUS_DT - Status Date Date   Stat Dt PERSON_CHECKLST
  TRACKING_SEQ - Tracking Sequence Num3.0   Sequence PERSON_CHECKLST
  VAR_DATA_SEQ - Variable Data Sequence Number Num4.0   Var Data Seq No PERSON_CHECKLST
  DEFAULT_DUE_DT - Default Due Date Date   Due Date CS_CHKLST_TBL
  DESCR - Description -  Comment_DESCR Char30   Descr CS_CHKLST_TBL
  SCC_CHECKLIST_TYPE - Checklist Type Char3 N Checklist CS_CHKLST_TBL
  TRACKING_GROUP - Tracking Group Char6   Track Grp CS_CHKLST_TBL
Submit an Inquiry or Request to DARTS Print Article

Related Services / Offerings (1)

DARTS (UMS Data) Inquiry
Submit an inquiry about UMS Data (except Data Governance)