CULLINET GENERAL LEDGER (CGL) IMPLEMENTATION OBJECTIVES, TASKS, AND SUB-TASKS - 11 APRIL 1986

• Document Type: CREST
• Collection: General CIA Records
• Document Number (FOIA) /ESDN (CREST): CIA-RDP90-00191R000100060044-9
• Release Decision: RIPPUB
• Original Classification: K
• Document Page Count: 14
• Document Creation Date: December 23, 2016
• Document Release Date: October 24, 2013
• Sequence Number: 44
• Publication Date: April 11, 1986
• Content Type: MISC

lOt Reclassified in Part - Sanitized Copy Approved for Release 2013/10/24: CIA-RDP90-00191R000100060044-9
Cullinet General Ledger (CGL) Implementation
Objectives, Tasks, and Sub-Tasks - 11 April 1986
PHASE I
Objective: CGL Software Familiarization
Tasks:
A. Review GL51 Class Aids "Introduction to GI.'
1. Review system definition
2. Review journal entry
3. Review posting cycle processing
4. Review financial reporting
B. Review GL52 Class Aids, "System Definition"
1. Review System control parameters
2. Review organizational data and processing controls
3. Review chart of accounts definition
3/3 - 4/30
Completed except Item I.D.4.
3/3 - 3/9 .
Completed
All
3/10 - 3/16 All I.A.
Completed
Declassified in Part - Sanitized Copy Approved for Release 2013/10/24: CIA-RDP90-00191R000100060044-9
STAT
STAT
Declassified in Part - Sanitized Copy Approved for Release 2013/10/24: CIA-RDP90-00191R000100060044-9
C. Review GL53 Class Aids, "GL Posting Cycle Reporting"
1. Review user-defined posting cycle reports
2. Review additional reporting concepts
3. Review CULPRIT reporting
D. Install the Software
1. Make arrangements for installation
2. Schedule the installation
3. Ensure installation by Cullinet Reps is successful
4. Double check the proper installation of the EXECS
(See Attachment No 1)
5. Test on-line standards (using GTCC)
6. Prepare Culprit reports (See Attachment No 3,
"Culprit Library of Routines", Table 1-1) -
execute as needed
7. Run selected GL batch programs (See Attachment No 4,
"Culprit Library of Routines", Table 2-1) -
execute as needed
8. Correct any installation discrepancies
2
3/17 - 3/23 All I.B.
Completed
2/24 Bret, Jack
Weekly Status
fiCf?
Ill - PO" ulived-t
eaptit 7)172_ stynt en)41 tts) .bat Sijfkify, gal*ArArt-
hel-st-Lrc Prr af7w ape/4Mo)- rwt ,
Declassified in Part - Sanitized Copy Approved for Release 2013/10/24: CIA-RDP90-00191R000100060044-9
Declassified in Part - Sanitized Copy Approved for Release 2013/10/24: CIA-RDP90-00191R000100060044-9
E. Execute Cullinet Demonstration Model (GTCC)
1. Reexamine critical screens (using Cullinet 'Guide to
Implementation" - See Attachment No 2)
2. Study Lab. exercises in Work Books for GL51, GL52, and GL53
3. Practice data input (using Cullinet General Reference
Manuals Vol I and Vol II as a guide)
4. Prepare Culprit reports (See Attachment No 3,
'Culprit Library of Routines', Table 1-1) ?
5. Run selected batch programs (See Attachment No 4
"Culprit Library of Routines", Table 2-1)
6. Check CGL database space statistics daily
(a) See Attachment No 5
F. Attend Cullinet Training Course GL54
"Transaction Processing"
G. Attend Cullinet Training Course GL58
'Technical Introduction to GI.'
3
3/24 - 4/23
Completed
3/17 - 4/30
Completed
4/15 - 4/30
Completed
4/15 - 4/30
Completed
Continuous
4/24 - 4/25
Completed
4/28 - 4/30
Completed
All
All
Jack
Jack
Jack, Bret
Nina, Jack
Dick
Karen, Jack
Bret
Declassified in Part - Sanitized Copy Approved for Release 2013/10/24: CIA-RDP90-00191R000100060044-9
I.D.4
I.D.4
I.B.
/.A./I.B.
Declassified in Part - Sanitized Copy Approved for Release 2013/10/24: CIA-RDP90-00191R000100060044-9
PHASE II
Objective: Initial System Definition Test and Evaluation
(IC Staff Model) (Scope is ?to test G.L. balances
and reports with limited test of detail transactions)
Tasks:
4/28 - 8/15 II.?.
A. Define the System Features Required to Accomplish the 4/28 - 6/30
Objective
1. Identify the organization for the initial system
definition, test & evaluation model
(a) IC Staff
2. Verify knowledge of current selected organization
with all team members
(a) Read available file material
3. Arrange for briefing on selected organization's
operations and functions (set for 5/5)
4. Develop the structure of the account key
(Org - Acct - Center)
5. Identify the IC Staff "Orgs" for:
(a) Annual Appropriations
(1) See Attachment No 6
(b) Reimbursement activities
(1) See Attachment No 6
(c) Working fund advances
(1) See Attachment No 6
601'fbv/P-4- All
4/14 - 4/1:344
Completed
Completed
Completed
All /I.A.3
Nina II.A.2
Nina II.A.5/11.A.6/11.A.9
Nina II.A.1
Declassified in Part - Sanitized Copy Approved for Release 2013/10/24: CIA-RDP90-00191R000100060044-9
Declassified in Part - Sanitized Copy Approved for Release 2013/10/24: CIA-RDP90-00191R000100060044-9
6. Define control structures for each organization
(1) See Attachment No 7
(a) Define low level centers
(1) 42 low-level centers
(b) Define summary centers
(1) one summary center
(c) Define consolidated centers, if required
(1) Not applicable for IC Staff
7. Define reporting structures
(a) TBD (very little work)
8. Identify, define, and code the user required reports
to be produced in Phase II (See Attachment No 8)
(a) Identify the system produced reports that require
no additional coding
(1) See Attachment No 8 - General Ledger Reports
(except distribution journals)
(a) Eight reports have been identifiecr
(b) Set up screens for these reports
(b) Identify and define those reports that require
additional coding
5/89 All
-6/4 4a SaM fsCL dint
.5(31 itt1 n-nfbAll
414-0 oUtila
All
5/t/6/30 All
6/16 - 6/30 All
Nina
90% completed
II.A.6/II.A.10
//.A.7
4W
&2I
ariliftek
thl.t-
60 sited, skthoC
C 41,e? empethot_
dia Awl kip-it 1-14
+ m4,44
hod- !ARA)
5/1 - 6/30 All
(1) See Attachment No 8 - Monthly Subsidiary
Ledger Reports
(a) Cullinet Culprit Training
e6/4-- 6/ 6
(b) Eighteen reports have been identified
5/5 - 5/9
code these reports
PN/
(c) Representative Report Analysis
----(d) Representative Coding and Test
0 -14tiA3506?
6/19 - 7/11
C.
etvpii.cl-- 4-o -4144
b1,4 41,70/___
1161q?
411 341/f-
Jack,Karen
Nina ,Jack
Jack
alc
4-ce_ 3 1 0 3
w
Declassified in Part - Sanitized Copy Approved for Release 2013/10/24: CIA-RDP90-00191R000100060044-9
)
JILL
Declassified in Part - Sanitized Copy Approved for Release 2013/10/24: CIA-RDP90-00191R000100060044-9
(c) Define new reports that will require design and
coding
(1) Identify these new reports
(2) Design the new report layouts
(3) Code the new reports
(a) Specific new reports are TBD
buliori)-
--dts-
9. Define the chart of accounts for the IC Staff
(See Attachment No 9) (5 orgs)
(a) Identify accounts associated with other
software packages
10. Establish account/low-level center
(a) To be established on-line
11. Define the date calendar
(a) Prepared on-line
5/1 - 6/30 All
Licci-tAiug, 004 I-6) etA-Itt 'the ?11,64 IAA, 139i-Z
o+or. roAim
,s4C
_ 5/21 Nina,Dickpo .
e_ketid sr-8
.htt I NJ /,'/) tettAf
431 ola errri
? I IS 7
relationships
-
relationships q
4/13/ a_te
12. Define the types of accounting information required
(a) Number of years history to be loaded
(1) N.A
(b) Number of budgets
(1) N.A.
ubledgers
(1) To be established on-line
(d) Analysis and exception reports
(1) TBD 54 I
(e) Reconciliat ons
(1) TBD
(f) Consolidati s
(1) N.A. -- -kb
(g) Statistical accAnts
(1) N.A.
(h) Other
(1) VW
/3 r r
5/2
Nina
C?4CY exctpt Z5.4
? - 5/9
- 5/9
sp
3414c 117\-oit)-62,-
- 5/9
FG5/11/41.._ klutorl itt,04,,442.4
6
TDB
II.A.6/II.A
Nina, Dick , II.A.8//I.A.9
/I.A.10
_SL(Li
- tl.ltLi. oa
3/ Uthli
Declassified in Part - Sanitized Copy Approved for Release 2013/10/24: CIA-RDP90-00191R000100060044-9
4.0
Declassified in Part - Sanitized Copy Approved for Release 2013/10/24: CIA-RDP90-00191R000100060044-9
fit ie,a04.14A 4,0 / v
5 '
116 -
13. Analyze requirements for on-line summary accounts' 5/19 - 5/31
and define summary structures and acronyms -a 6,1-ru haat
els 77321 gtV4
1 , /4011 -t-
7
.e...31- Oo 4.c41 ?
6/12 - 6/18 Nina, Dick
14. Define journal entries
(a) Standard Journal entries
(1) TBD
(b) Repeating Journal entries
(1) TBD
(c) Journal entry ID numbers
(1) TBD
15. Select system report options
(412z rit,dirtuf birkeui. tv-nad .5-71)
dyyptt_ot- jy;-htul- dry -111,0 #a-j-c)
II.A.6/11.A.7
16. Review system design for IC Staff with Cullinet
Representatives
6/7 - 6/10
6/19 - 6/20
17. Take a backup of database 6/20
B. Determine the Input to be Used in Testing the Defined 6/16 - 7/25
System
I 01. D termine wh t to test - 6/23
2. i4t th features (functions to be tested using the
C S ff Model) 95% Completed
Fiscal Accounting and Reporting
(1) Fund availability
(2) Fund distribution
(3) Fund application
(4) Fiscal reporting
All
All
Bret, Jack
Dick
Dick
Declassified in Part - Sanitized Copy Approved for Release 2013/10/24: CIA-RDP90-00191R000100060044-9
II.B.1
Declassified in Part - Sanitized Copy Approved for Release 2013/10/24: CIA-RDP90-00191R000100060044-9
(4/Financial Accounting and Reporting
(1) Assets
(2) Liabilities
(3) U.S. Government investment
(4) Memorandum accounts
(5) F&A reporting
(a) System generated reports
(b) User defined reports
.1",cartilks
3. Define the datal(to e used for the test
iscal accounting and reporting
(1) Receipt of quarterly apportionment
(Supplemental or Continency Resolution)
(2) Receipt of Advances from OGA
(3) Reimbursement receipts
(4) Recording Treasury warrants
(5) Allotments
(6) Obligations
(7) Expenditures
(8) Adjustments
(9) System generated reports
(10) User-defined reports
(b) Financial Accounting and Reporting
(1) Cash
(2) Receivables
(3) Advances
(4) Property
(5) Miscellaneous Assets
(6) Accounts Payable
(7) Accountability to OGA
8
G/25- 27
Nina, Dick
Declassified in Part - Sanitized Copy Approved for Release 2013/10/24: CIA-RDP90-00191R000100060044-9
Declassified in Part - Sanitized Copy Approved for Release 2013/10/24: CIA-RDP90-00191R000100060044-9
(8) Other Liabilities
(9) Income (Reimbursements)
(10), Miscellaneous Memo Accounts
(11) Financial Reporting
(a) System Generated reports
(b) User defined reports
the types of transactions to be processed
. Travel'
(1) Advances
(2) Accounting
b. Contracts
(1) Governmental and Non-Governmental
(2) Maintenance and Service
(3) Procurement
(4) Other
c. Rental Transactions---" two cA/
d. Purchase Orders
e. Reimbursements (1080's)
f. OGA Advances
g. Expenses
h. Collections and Disbursements
i. Other (TBD)
6/30
90% Completed
5. Spfcify the data to be used for the test
terA minimum of five transactions for each type of
transaction listed in 11.5.3 and 11.5.4 will be
processed so as to record entries in each GL account.
These transactions will be based upon sample data
fabricated for the IC Staff Model.
Nina, Dick II.5.1/II.5.2/
II .8.3
113- 246
All I/.5(A11)
9
Declassified in Part - Sanitized Copy Approved for Release 2013/10/24: CIA-RDP90-00191R000100060044-9
Declassified in Part - Sanitized Copy Approved for Release 2013/10/24: CIA-RDP90-00191R000100060044-9
'43 - 7/7,5
epare a representative number of typical input -8111-12,-6713-0-
documents
a. Sample input data will be developed at a later date
(see II.B.5 above)
fine adequate control and balancing procedures
. Post test transactions to a worksheet - show
dollar totals
b. Run the posting cycle (how many?)
c. Produce a Trial Balance
d. Check Trial Balance against worksheet
(pre-determined totals)
e. Prepare detailed reports and check against worksheet
f. Check rejections to appropriate reports
8. Evaluate the need for additional edits
a. IDD usage
b. field Sye
c. Numerics
9. Identify job streams for test
10. Review decisions
C. Set Up Data Processing Standards and Procedures
1. Establish data processing requirements
(a) Review material covered in technical
indoctrination course
(b) Study the systems guide
- 10 p6a'
JThpvee'i-
1/3
0_
All II.B(A11)
Nina,Dick
, 7/3 - 7/25 Jack
6/23 - 7/4
7/23 - 7/25 All
Not Applicable in Phase I/
Not Applicable in Phase II
e4,26-)
twolvvicf I bite
toostIvi,? -/-0 tAni-r -4 AP ,vf
II -A0 matt sim'e ace] Ay-6-1c c AV_
10
Declassified in Part - Sanitized Copy Approved for Release 2013/10/24: CIA-RDP90-00191R000100060044-9
Declassified in Part - Sanitized Copy Approved for Release 2013/10/24: CIA-RDP90-00191R000100060044-9
(c) Determine user needs (IC Staff test criteria)
for processing schedules
(1) Daily bi-weekly, weekly, monthly, quarterly,
semi-annual, annual postings
(2) Daily system definition maintenance
(3) Monthly, quarterly, annual required reports
(4) Data purge to history file
(5) Daily review of system produced reports
(6) See II.C.2(a) below
(d) Establish processing schedule
2. Create required job streams
(a) List the jobs to be run
(1) Include job streams for item II.C.1(c) above
(b) Copy/modify JCL
(1) TBD
(c) List all JCL streams
(1) TBD
D. Develop Interfaces and Conversion Programs, If Required
(This task is necessary if non-Cullinet software is going
to be used to feed data into the system or if data is
going to be converted from an existing system for the
IC Staff Model. It will be more applicable during later
Phases of the CGL Implementation Plan)
1. Develop required conversion programs
(a) Determine what data (if any) needs to be converted
(b) Write the programs required to convert the needed data
(c) Code and test the programs
(d) Develop documentation for the conversion programs
11
Not Applicable in Phase II
Not Applicable in Phase /I
Declassified in Part - Sanitized Copy Approved for Release 2013/10/24: CIA-RDP90-00191R000100060044-9
II.C.2(n)
?, Declassified in Part - Sanitized Copy Approved for Release 2013/10/24: CIA-RDP90-00191R000100060044-9
2. Develop required interface programs
(a) Review data (if any) to be passed from system to system
(b) Develop program specifications, as required
(c) Code and test the programs
(c) Develop documentation for the interface programs
E. Determine and Implement Security Requirements
(Data to be used for the IC Staff Model test will be
unclassified. This task will be more significant in later
phases of the CGL Implementation Plan.
1. Determine security requirements for IC Staff Model test
2. Establish preliminary security procedures, if required
3. Extend the security procedures, as required
4. Review application specific security, if applicable
Not Applicable in Phase II
F. Set Up the Test Database for the IC Staff Model
4/8
9Q
1.
Determine the size of the test database
2/3
2.
In coordination with CDS, physically allocate
space
and initialize the test database
4/8
3.
Set up the base test system in coordination with
a. Execute the system definition parameters
b. Enter master file information
DBCC
4/15
c. Enter other pertinent information
d. Save the test database (coordinate with DBCC)
12
4/22 Jack Bret I.D
Completed
- 2/7 Jack I.E.6
/15 Jack, Bret I.E.6
/22
Jack, Bret
Declassified in Part - Sanitized Copy Approved for Release 2013/10/24: CIA-RDP90-00191R000100060044-9
Declassified in Part - Sanitized Copy Approved for Release 2013/10/24: CIA-RDP90-00191R000100060044-9
G. Run the Test (see Task II.B, this Phase)
7/17 - 8/10
All
/I.B
1. Enter the sample transaction package (input document)
into the journals
7/17 - 8/10
All
11.8.6
2. Execute all relevant inquiries
7/21 - 8/10
All
//.G.1
3. Perform posting cycle processing
(a) Run all selected batch jobs (See Attachment No 4)
(b) Review output from batch jobs
7/17 - 8/10
All
/I.G.1
4. Prepare selected Culprit reports (e.g. Trial Balance)
7/21 - 8/10
All
(See Attachment No 3)
5. Optionally, restore database, modify input data, and
repeat this task
7/17 - 8/10
All
11.9
6. Document the results of the test
8/3 - 8/10
All
/I.H./II./.
(See Attachment No 10, Section V)
7. Review results with Cullinet Support Rep
6/7 - 8/10
All
H. Develop Documentation
1. Establish policy for documentation
(a) Set documentation standards
2. Determine user documentation
(a) Design coding forms
(b) Design procedural documentation
13
8/11 - 8/12 Karen, Tom, Nina,
Jack, Dick, etc.
All
Not applicable in Phase II
Declassified in Part - Sanitized Copy Approved for Release 2013/10/24: CIA-RDP90-00191R000100060044-9
II.A. - II.G.
Declassified in Part - Sanitized Copy Approved for Release 2013/10/24: CIA-RDP90-00191R000100060044-9
3. Determine data processing documentation
Not applicable in Phase II
(a) Document JCL streams
(b) Write operator's run book
(c) Construct system diagram
4. Document an 'Issues List" for Phase II
I. Evaluate and Report the Results of Phase II Actions
(See Attachment No 10, Section V)
4/28
8/11
- 8/15
- 8/15
1. Evaluate the results of Phase II (Emphasize test data)
8/3
- 8/11
2. Review the results of Phase II actions with:
(a) ABE Team members
(b) Cullinet Support Reps
(c) BARS Project Leaders
8/11
- 8/12
3. Publish Phase II results
8/11
- 8/15
4. Obtain approval to proceed to Phase III
8/15
- 8/15
All II.A. - IT.G.
All
All II.G.6
II.A. - II.G.
All II.G.6
II.G.7
All II.G.6
All II.I.2(c)
J. Preparation for Phase III - db sizing --8-141-- Bret, Jack
(/4
14
Declassified in Part - Sanitized Copy Approved for Release 2013/10/24: CIA-RDP90-00191R000100060044-9