ACCALX FILE Activity Calendar Detail This file contains detailed calendar information from AC00.2 (Calendar). It includes calendar name, fiscal year, period, and period end date. REFERENCED BY AC120 AC121 AC123 AC127 AC130 AC160 AC165 AC170 AC190 AC191 AC20.1 AC20.2 AC20.3 AC20.4 AC21.1 AC21.2 AC21.3 AC22.1 AC27.1 AC295 AC297 AC30.2 AC30.3 AC310 AC32.1 AC40.1 AC41.1 AC42.1 AC470 AC530 AC580 AC65.1 AC65.2 AC90.1 AC90.2 AC95.1 AC95.2 AC96.1 AC97.1 AC97.2 AC980 ACAC.1 ACDL.1 AP125 AP126 AP170 AP193 AP225 AP226 AP25.1 AP25.2 AP26.1 AP30.2 AP30.4 AP32.2 AP520 AP981 AR115 AR124 AR190 AR20.1 AR21.1 AR21.2 AR21.3 AR24.1 AR29.2 AR30.1 AR30.2 AR30.4 AR42.1 AR42.2 AR42.7 AR43.1 AR560 AR570 AR575 AR580 BL120 BL130 BL20.1 BL20.3 BL21.2 BL21.5 BL29.1 BL29.2 BL520 BL820 BL92.1 BL940 BN150 CB10.1 CB180 CB191 CB20.1 CB30.1 CB80.1 CB980 EE135 EE35.1 EE35.2 EE520 GL199 DR100 IC130 IC141 IC142 IC83.1 IFGT.1 IN20.1 MA40.1 MA41.4 MA41.6 MA43.3 MA43.4 MA520 MA530 MA540 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE113 OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE30.1 OE30.2 OE30.3 OE30.4 OE30.5 OE30.6 OE30.7 OE30.9 OE510 OE810 OE830 OE920 OE950 PO100 PO135 PO180 PO20.1 PO21.1 PO21.2 PO21.3 PO21.5 PO21.6 PO22.1 PO22.2 PO22.3 PO25.1 PO25.2 PO25.4 PO26.1 PO28.6 PO30.1 PO31.1 PO32.1 PO33.1 PO34.1 PO35.1 PO530 PO821 PO990 PR128 PR131 PR132 PR134 PR136 PR137 PR140 PR150 PR195 PR199 PR32.1 PR32.2 PR33.1 PR33.2 PR33.3 PR35.1 PR35.2 PR35.3 PR35.4 PR35.5 PR35.6 PR35.8 PR36.1 PR37.1 PR38.1 PR45.1 PR530 PR80.1 PR82.1 PR85.1 PRSA.1 UK102 UK330 RQ10.1 RQ10.2 RQ10.3 RQ11.1 RQ12.1 RQ13.1 RQ20.1 RQ20.3 RQ20.4 RQ35.1 RQ500 RQ990 UK120 WH130 WH132 WH190 WH20.2 WH20.7 WH30.1 WH30.2 WH30.3 WH31.1 WH31.2 WH31.3 WH32.1 WH32.2 WH32.3 WH33.1 WH33.2 WH33.3 WH33.4 WH33.5 WH33.6 WH33.8 WH33.9 WH34.1 WH34.2 WH34.3 WH34.4 WH40.1 WH40.2 WH520 WH830 WO132 WO140 AC54.1 AC540 UPDATED BY AC00.2 AC730 FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY CDD-CALENDAR-NAME Alpha 12 AC00.2 AC730 Calendar Name Required key. This is the name of the calendar. CDD-FISCAL-YEAR Numeric 4 AC00.2 AC730 Fiscal Year Required key. This is the fiscal year for the calendar. CDD-PERIOD Numeric 2 AC00.2 AC730 Period Required key. This is the fiscal period for the calendar. CDD-PER-END-DATE Numeric 8 (yyyymmdd) AC00.2 AC730 Period End Date This is the period end date for this fiscal period. ACCALX FILE INDEX NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN CDDSET1 CALENDAR-NAME AC00.2 AC120 FISCAL-YEAR AC121 AC123 PERIOD AC127 AC130 AC160 AC165 AC170 AC190 AC191 AC20.1 AC20.2 AC20.3 AC20.4 AC21.1 AC21.2 AC21.3 AC22.1 AC27.1 AC295 AC297 AC30.2 AC30.3 AC310 AC32.1 AC40.1 AC41.1 AC42.1 AC470 ... CDDSET2 CALENDAR-NAME AC00.1 AC00.2 PER-END-DATE AC120 AC121 FISCAL-YEAR AC123 AC127 AC130 AC160 AC165 AC170 AC190 AC191 AC20.1 AC20.2 AC20.3 AC20.4 AC21.1 AC21.2 AC21.3 AC22.1 AC27.1 AC295 AC297 AC30.2 AC30.3 AC310 AC32.1 AC40.1 AC41.1 AC42.1 ... ACCALX FILE RELATIONS ONE TO ONE RELATIONS RELATION RELATED NAME FILE INTEGRITY RULES / FIELD MATCH Accal ACCAL Required CDD-CALENDAR-NAME -> CDH-CALENDAR-NAME CDD-FISCAL-YEAR -> CDH-FISCAL-YEAR |