UM_ITYP_FA_VW - FA view of Item Types

Body

 

WARNING:  Field Name Definitions are Linked to the UMS Data Cookbook - this requires a University of Maine System ID and password

This table includes a detailed list of Financial Aid item types with Financial Tree structure information by aid year.

Detailed Information

Data Systems

PeopleSoft Campus Solutions - CSPRD
PeopleSoft Campus Solutions Reporting - CSRPT

Source Tables

ITEM_TYPE_FA 
ITEM_TYPE_TBL
UM_ITYP_TREENDS 

View SQL Code
Download SQL Code

Key Record.Fieldname Format XLAT Heading Text
  AGGREGATE_AREA - Aggregate Area Char10   Aggr Area
Key AID_YEAR - Aid Year Char4   Aid Yr
  CHARGE_PRIORITY - Charge Priority List Char8   Charge Lst
  DESCR - Description Char30   Descr
  DESCRSHORT - Short Description Char10   Short Desc
  DISBURSE_METHOD - Disbursement Method Char1 N Method
Key EFFDT - Effective Date Date   Eff Date
  EFF_STATUS - Status as of Effective Date Char1 N Status
  FA_SOURCE - Source Char1 N Source
  FEDERAL_ID - Federal ID Char4 N Federal ID
  FED_OR_INST - Fed/Inst Affected Char1 N Apply to
  FIN_AID_TYPE - Fin Aid Type Char4 N Finaid Typ
Key ITEM_TYPE - Item Type Char12   Item Type
  ITEM_TYPE_CD - Item Type Code Char1 N Item Code
  KEYWORD1 - Key Word Char10   Key Word
  KEYWORD2 - Key Word 2 Char10   Key Word 2
  KEYWORD3 - Key Word 3 Char10   Key Word 3
  LOAN_PROGRAM - Loan Program Char1 N Loan Prog
  NEED_BASED - Need Based Char1   Need Based
  REPORT_CODE - Institution Reporting Cd Char4   Rprt Cd
Key SETID - SetID Char5   SetID
  TITLE_IV - Title IV Aid Char1   Title IV
  UM_GASB_1 - Item Type GASB Node 1 Char20   GASB Node 1
  UM_GASB_2 - Item Type GASB Node 2 Char20   GASB Node 2
  UM_GASB_3 - Item Type GASB Node 3 Char20   GASB Node 3
  UM_GASB_4 - Item Type GASB Node 4 Char20   GASB Node 4
  UM_GASB_5 - Item Type GASB node 5 Char20   GASB Node 5
  UM_SCRTY_1 - Item Type Security Node 1 Char20   Scrty Node 1
  UM_SCRTY_2 - Item Type Security Node 2 Char20   Sctry Node 2
  UM_SCRTY_3 - Item Type Security Node 3 Char20   Scrty Node 3
  UM_SCRTY_4 - Item Type Security Node 4 Char20   Scrty Node 4
  UM_SCRTY_5 - Item Type Security Node 5 Char20   Scrty Node 5
  UM_SCRTY_6 - Item Type Security Node 6 Char20   Sctry Node 6
  UM_SCRTY_7 - Item Type Security Node 7 Char20   Scrty Node 7
  UM_SCRTY_8 - Item Type Security Node 8 Char20   Scrty Node 8

Details

Details

Article ID: 158889
Created
Fri 5/10/24 4:27 AM
Modified
Tue 9/17/24 3:29 PM
Applies To
Faculty
Staff
Community

Related Services / Offerings

Related Services / Offerings (1)

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

Attachments

Attachments (1) Sort By: Sort Attachments ByName Sort Attachments ByDate

txt

SQL code for UM_ITYP_FA_VW.txt Computer

Tue 9/17/24 3:24 PM
View
;