CAL_DETP_TBL - Detail Calendar Periods

Body

 

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

Financials Calendar Table with Accounting Periods

Detailed Information 

  • PeopleSoft Finance Legacy Database that will be replaced by the ERP Cloud Database in 2025

Environment

  • PeopleSoft FNPRD Database Table
     
Key Record.Fieldname Format Heading Text
key ACCOUNTING_PERIOD - Accounting Period Num3.0 Period
  ALLOC_UPDATE_SW - Allocation Update Switch Char1 Al Upd Sw
  BEGIN_DT - Begin Date Date Begin Date
key CALENDAR_ID - Calendar ID Char2 Calendar
  END_DT - End Date Date End Date
key FISCAL_YEAR - Fiscal Year Num4.0 Year
  PD_ALLOC - Period Allocation Num4.15 Pd Alloc
  PD_ALLOC_TOTAL - Total Allocation Periods Num4.15 Pd All Tot
  PERIOD_ABBRV - Abbreviation Char3 Abbrev
  PERIOD_NAME - Period Name Char30 Per Name
key SETID - SetID Char5 SetID

 

Details

Details

Article ID: 158745
Created
Fri 5/10/24 4:25 AM
Modified
Wed 7/31/24 11:56 AM
Applies To
Staff

Related Services / Offerings

Related Services / Offerings (1)

Submit an inquiry about UMS Data (except Data Governance)