LoLA — Log On Louisiana
1 of 1
https://my.lctcs.edu/cp/home/displaylogin
Log into LoLA
LoLA (Log On Louisiana) is a powerful new online tool that will allow you to completely manage your college career. LoLA will be your 24/7, one stop resource for the upcoming semester. You can use LoLA to: monitor your financial aid application, register for classes, review your class schedule, check on important upcoming dates, and catch up on campus news and announcements. Need help? Send an email to
[email protected] or call the Support Line at 855-227-8102.
© Copyright 2012 LCTCS, All Rights Reserved. LCTCS is governed by the Louisiana Board of Regents. Some icons by Yusuke Kamiyamane. All rights reserved. Licensed under a Creative Commons Attribution 3.0 License.
LCTCS 265 South Foster Drive Baton Rouge, LA 70806
10/14/2013 9:49 AM
LoLA -- Log on Louisiana
1 of 2
https://my.lctcs.edu/tag.4326f1c0dad60ee5.render.userLayoutRootNode.uP?uP_root=root&uP_sp...
Welcome Quintesah Syas Content Layout
You are currently logged in. Logout
Help
October 14, 2013
Welcome to LoLA Welcome LoLA (Log-On Louisiana) a powerful new online tool that will allow you to completely manage your college career. LoLA will be your 24/7, one stop resource for the upcoming semester. You can use LoLA to: Monitor your financial aid application Register for classes Review your class schedule View your work study or student worker schedule Check on important upcoming dates Catch up on campus news and announcements
Announcements There are no announcements
Password Expiration Your password will expire in 0 days! You must change your password prior to 10/15/2013 in order to continue using LoLA.
If you need assistance with LoLA, please send an email to
[email protected] or call the Support Line at 855-227-8102.
Internet Native Banner Banner Security Forms
Internet Native Banner Direct Single Sign-On Link to Internet Native Banner
Baton Rouge Community College Banner/Cognos (Finance) Banner/Cognos (Financial Aid) Banner/Cognos (HR) Banner/Cognos (Student AR) Banner/Cognos (Student Admissions)
Self Service Self Service provides access to information based on your college and role. Links below will be displayed for each college you are affiliated with. Select the appropriate college to view your information choices for that college.
Baton Rouge Community College Click here (even if you're department is formerly from CATC)
10/14/2013 9:33 AM
LoLA -- Log on Louisiana
1 of 1
https://my.lctcs.edu/cp/render.UserLayoutRootNode.uP?uP_tparam=utf&utf=https://my.lctcs.edu/...
Back to MyLCTCS Tab
Logout
Help
Your current Institution is Baton Rouge Comm College
Personal Information Update addresses, contact information or marital status; review name or social security number change information; Change your PIN; Customize your directory profile.
Employee Time sheets, time off, benefits, leave or job data, paystubs, W2 forms, W4 data.
Finance Create or review financial documents, budget information, approvals.
RELEASE: 8.5.2
click here
10/11/2013 4:11 PM
Finance
1 of 1
https://ssb.lctcs.edu:9040/PROD_BRCC/twbkwbis.P_GenMenu?name=bmenu.P_FinanceMnu
Your current Institution is Baton Rouge Comm College
Click here Budget Queries Requisition Approve Documents View Document RELEASE: 8.4
10/14/2013 9:32 AM
Budget Queries
1 of 1
https://ssb.lctcs.edu:9040/PROD_BRCC/bwfkrpvu.P_Budget_Start
Your current Institution is Baton Rouge Comm College
To create a new query choose a query type and select Create Query. To retrieve an existing query choose a saved query and select Retrieve Query.
Create a New Query
ensure this option is selected
Type
Click here once "type" is confirmed
Retrieve Existing Query Saved Query
RELEASE: 8.3
10/11/2013 10:06 AM
Budget Queries
1 of 1
https://ssb.lctcs.edu:9040/PROD_BRCC/bwfkrpvu.P_Budget_Start
Your current Institution is Baton Rouge Comm College
Select the Operating Ledger Data columns to display on the report. Original Budget
YTD Actual Rev/Exp
Budget Adjustments
Enc's and PO's
Total Budget
Requisitions
Temporary Budget
Total Encumbrances
Monthly Budget
Available Balance
select all highlighted items (nothing else should be selected)
Save Query as: Shared
Click here once selections are made RELEASE: 8.3
10/11/2013 10:07 AM
Budget Queries
1 of 1
https://ssb.lctcs.edu:9040/PROD_BRCC/bwfkrpvu.P_Budget_Start
Your current Institution is Baton Rouge Comm College
For a Budget Query to be successful, a user with Fund Organization query access must enter a value in either the Organization or Grant fields as well as the Fiscal Year, Period, and Chart of Accounts fields. If Grant information is queried, all retrieved information is Grant Inception to Date. Otherwise, all information retrieved is through the Fiscal Year to Date. To perform a comparison query select a Comparison Fiscal Year and Period in addition to the required Fiscal Year and Period. With this selection, all details retrieved will be placed next to the corresponding comparison fiscal period. Fiscal year:
Fiscal period:
Comparison Fiscal year:
Comparison Fiscal period:
Commitment Type:
(enter your department's fund #)
Enter information as shown in each box. Information in each boxed category should be the same every time you run a query (exception: Fiscal Year shoulbe be changed when a new fiscal year begins.)
(enter your department's org #)
enter %BA% or %BE% to filter by campus code (otherwise, leave blank)
Include Revenue Accounts Save Query as: Shared
RELEASE: 8.3
Click here once all items are entered
10/11/2013 10:07 AM
Report A
1 of 3
https://ssb.lctcs.edu:9040/PROD_BRCC/bwfkrpvu.P_Budget_Start
Your current Institution is Baton Rouge Comm College Select a link from an amount column in the Query Results list to retrieve detail information for the specific item chosen. Select one of the Download options to download Budget Query data to a Microsoft Excel spreadsheet. Calculate user defined columns for the query by making selections from the Compute Additional Columns pull down lists. Select a link from the Account column in the Query Results list to retrieve payroll expense detail information for a specific account, or use the Payroll Expense Detail button to retrieve information for all accounts in the query.
Campus Codes: BA = Mid-City (Main Campus) BE = Acadian (formerly CATC)
Report Parameters Organization Budget Status Report
By Account
Period Ending Jun 30, 2013
Account Code Legend: 60XXBA = Salaries (deduct from 600RBA line) 61XXBA = Related Benefits (deduct from 610RBA line) 70XXBA & 71XXBA = Operating Services (deduct from 700RBA line) 72XXBA = Operating Supplies (deduct from 720RBA line) 73XXBA = Professional Services (deduct from 730RBA line) 74XXBA = Other Charges (deduct from 740RBA line) 75XXBA = Capital Outlay (deduct from 750RBA line) 76XXBA = Computers & Software (deduct from 760RBA line) 77XXBA = Travel (deduct from 770RBA line) 78XXBA = Other Operating Expenses (deduct from 780RBA line)
As of Oct 14, 2013 Chart of Accounts L LCTCS Commitment Type All Fund 215018 NSF - Step Grant Program All Department 161004 Prec Trds-Civil Engineering Tech Activity All Account All Location All
Every time the account code is XXXRBA ("R" in front of the campus code), that represents the budgeted amount for the applicable budget category (i.e. 700RBA = Operating Services Budget amount).
See p.10 for description of each column listed in Query Results.
Query Results Account Account Title
FY13/PD12 FY13/PD12 FY13/PD12 FY13/PD12 FY13/PD12 FY13/PD12 FY13/PD12 FY13/PD12 I Available Original Budget YTD Actual Enc's and Requisitions Total D Total A B G H Encumbrances Balance J Budget C Adjustments Budget E Rev/Exp F PO's 6001BA Compensation 10,000.00 0.00 10,000.00 0.00 0.00 0.00 0.00 10,000.00 of Board Members 6003BA Unclassified 0.00 0.00 0.00 16,080.75 0.00 0.00 0.00 ( 16,080.75) Salaries 6006BA Adjunct 0.00 0.00 0.00 2,329.77 0.00 0.00 0.00 ( 2,329.77) Contracts
Click on numbers in blue for additional information on what makes up each amount.
10/14/2013 10:11 AM
Report A
2 of 3
https://ssb.lctcs.edu:9040/PROD_BRCC/bwfkrpvu.P_Budget_Start
Click on numbers in blue for additional information on what makes up each amount.
600RBA Salaries and Wages 6012BA Wages 6102BA Teachers Retirement Contributions 6103BA Teachers ORP Contributions 6105BA FICA Tax 6106BA Medicare Tax 6108BA OGB Medical Ins Contribution 610RBA Related Benefits - ER 700RBA Operating Services 7123BA Express Mail and Shipping 7201BA Office Supplies 720RBA Operating Supplies Screen total Running total Report Total (of all records)
115,118.00
0.00 115,118.00
0.00
0.00
0.00
0.00 115,118.00
0.00 0.00
0.00 0.00
0.00 0.00
530.32 2,737.28
0.00 0.00
0.00 0.00
0.00 ( 530.32) 0.00 ( 2,737.28)
0.00
0.00
0.00
126.30
0.00
0.00
0.00
0.00 0.00 0.00
0.00 0.00 0.00
0.00 0.00 0.00
459.63 268.14 1,068.80
0.00 0.00 0.00
0.00 0.00 0.00
0.00 ( 459.63) 0.00 ( 268.14) 0.00 ( 1,068.80)
20,051.00
0.00
20,051.00
0.00
0.00
0.00
0.00
20,051.00
1,000.00
0.00
1,000.00
0.00
0.00
0.00
0.00
1,000.00
0.00
0.00
0.00
20.92
0.00
0.00
0.00
( 20.92)
0.00
0.00
0.00
362.97
0.00
0.00
0.00
( 362.97)
2,850.00
0.00
2,850.00
0.00
0.00
0.00
0.00
2,850.00
0.00 149,019.00 0.00 149,019.00 0.00 176,019.00
23,984.88 23,984.88 37,668.49
0.00 0.00 0.00
0.00 0.00 0.00
0.00 125,034.12 0.00 125,034.12 0.00 138,350.51
149,019.00 149,019.00 176,019.00
( 126.30)
click here to see next 15 records
Shared
Click here to download query to Excel (to format and calculate actual available balances in each budget category). See sample formatted extraction on p.11.
Compute Additional Columns for the query Column 1 Operator Column 2
Display After Column
New Column Description
10/14/2013 10:11 AM
QueryResultsColumnLegend: A AccountCode(AlsoknownasObjectCode) B AccountCodeDescription C OriginalBudget(Amountloadedatthebeginningoffiscalyear) D BudgetAdjustments(Anybudgettransfersormidyearreductions/increases) E TotalBudget(SumofColumnsC&D) F YTDActualRev/Exp(YeartoDateActualRevenue/ExpenditurespostedtoBanner) G Enc'sandPO's(EncumbrancesandPurchaseOrdersthatwillbeprocessedlater[fundsaresetasidetobespentlater]). H Requisitions(Requisitionsthatwillbeprocessedlater[fundsaresetasidetobespentlater]). I TotalEncumbrances(SumofcolumnsG&H) J AvailableBalance(Sumofallamountslistedoneachrow.Thisisnottheactualavailablebalanceforthisapplicablebudgetcategory.)
FormattingQueryAfterDownloadingtoExcel ThepurposeofdownloadingthebudgetquerytoExcelistodeterminetheActualAvailableBalanceineachbudgetcategory. SuggestedFormatting: Expandallcolumnssotheentirecolumnheaderisvisible. Deletethecolumnscontaininginformationyoudon'tneed(e.g.Chart,FundType2,FundType2Title,FundType,FundTypeTitle,AccountType2,AccountType2Title,AccountType,AccountTypeTitle,Program,ProgramTitle). KeeptheHeaderdetailsincolumnA,asthisidentifieswhenthequerywasextracted. Addacolumntitled"ActualAvailableBalance"nexttothelastcolumn. PlacecursorincolumnAintherowbeneaththefirstcolumnheader,whichshouldbe"Fund".Click"View"onmenubarandselect"FreezePanes"then"FreezePanes"again.Thisallowsthecolumnheaderstoremainatthetopwhilescrollingupanddown. Insertablanklinebetweeneachbudgetcategory(70XX&71XX;72XX;73XX;74XX;75XX;76XX;77XX;78XX).Thishelpsorganizeeachbudgetcategory MovetheXXXRBAcategorylinetothetopofeachbudgetsection. Aftertheendofeachbudgetcategory,enteraformulainthe"ActualAvailableBalance"columnyouaddedtoSumallthe"AvailableBalance"linesineachcategory.TheXXXRBAlineispositiveandtheexpensetransactionsarenegativesodonotchangethesigns. ThetotalcalculatedbyyourformulaistheActualAvailableBalanceforeachbudgetcategory. Savethequerytoyourcomputer.Enterthequerydateasthetabnameintheworksheet.Namethefile"BudgetQueries(fundXXXXXXorgXXXXXX)".Createanewtabforeveryquery.
Sample formatted query extracted to Excel
OrganizationBudgetStatusReport ByAccount PeriodEndingJun30,2014 AsofOct11,2013 ChartofAccounts Fund Department Account Program Activity Location CommitmentType
L (Thiswillbeyourfund#) (Thiswillbeyourorg#)
LCTCS (Thiswillbeyourfundtitle) (Thiswillbeyourorgtitle)
All All All All All
Department
DepartmentTitle
(Thiswillbeyourfund#) (Thiswillbeyourfundtitle)
Fund FundTitle
(Thiswillbeyourorg#)
(Thiswillbeyourorgtitle)
(Thiswillbeyourfund#) (Thiswillbeyourfundtitle)
(Thiswillbeyourorg#)
(Thiswillbeyourorgtitle)
(Thiswillbeyourfund#) (Thiswillbeyourfundtitle)
(Thiswillbeyourorg#)
(Thiswillbeyourorgtitle)
(Thiswillbeyourfund#) (Thiswillbeyourfundtitle)
(Thiswillbeyourorg#)
(Thiswillbeyourorgtitle)
(Thiswillbeyourfund#) (Thiswillbeyourfundtitle)
(Thiswillbeyourorg#)
(Thiswillbeyourorgtitle)
(Thiswillbeyourfund#) (Thiswillbeyourfundtitle)
(Thiswillbeyourorg#)
(Thiswillbeyourorgtitle)
(Thiswillbeyourfund#) (Thiswillbeyourfundtitle)
(Thiswillbeyourorg#)
(Thiswillbeyourorgtitle)
(Thiswillbeyourfund#) (Thiswillbeyourfundtitle)
(Thiswillbeyourorg#)
(Thiswillbeyourorgtitle)
(Thiswillbeyourfund#) (Thiswillbeyourfundtitle)
(Thiswillbeyourorg#)
(Thiswillbeyourorgtitle)
(Thiswillbeyourfund#) (Thiswillbeyourfundtitle)
(Thiswillbeyourorg#)
(Thiswillbeyourorgtitle)
(Thiswillbeyourfund#) (Thiswillbeyourfundtitle)
(Thiswillbeyourorg#)
(Thiswillbeyourorgtitle)
(Thiswillbeyourfund#) (Thiswillbeyourfundtitle)
(Thiswillbeyourorg#)
(Thiswillbeyourorgtitle)
(Thiswillbeyourfund#) (Thiswillbeyourfundtitle)
(Thiswillbeyourorg#)
(Thiswillbeyourorgtitle)
(Thiswillbeyourfund#) (Thiswillbeyourfundtitle)
(Thiswillbeyourorg#)
(Thiswillbeyourorgtitle)
(Thiswillbeyourfund#) (Thiswillbeyourfundtitle)
(Thiswillbeyourorg#)
(Thiswillbeyourorgtitle)
(Thiswillbeyourfund#) (Thiswillbeyourfundtitle)
(Thiswillbeyourorg#)
(Thiswillbeyourorgtitle)
(Thiswillbeyourfund#) (Thiswillbeyourfundtitle)
(Thiswillbeyourorg#)
(Thiswillbeyourorgtitle)
(Thiswillbeyourfund#) (Thiswillbeyourfundtitle)
(Thiswillbeyourorg#)
(Thiswillbeyourfund#) (Thiswillbeyourfundtitle)
(Thiswillbeyourfund#) (Thiswillbeyourfundtitle)
Account 600RBA 6001BA 6003BA 6006BA 6012BA
AccountTitle SalariesandWages CompensationofBoardMembers UnclassifiedSalaries AdjunctContracts Wages
610RBA 6102BA 6103BA 6105BA 6106BA 6108BA
RelatedBenefitsER TeachersRetirementContributions TeachersORPContributions FICATax MedicareTax OGBMedicalInsContribution
OriginalBudget BudgetAdjustments TotalBudget YTDActualRev/Exp Enc'sandPO's Requisitions TotalEncumbrances 222,838.16 (10,000.00) 212,838.16 20,958.38 7,661.69 5,962.60
AvailableBalance AcutalAvailableBalance 212,838.16 (20,958.38) (7,661.69) (5,962.60) $ 178,255.49
35,842.85
35,842.85
6,545.03 778.53 393.91 485.89 1,800.75
35,842.85 (6,545.03) (778.53) (393.91) (485.89) (1,800.75) $ 25,838.74
700RBA OperatingServices 7123BA ExpressMailandShipping
1,979.08
1,979.08
16.57
1,979.08 (16.57) $ 1,962.51
720RBA OperatingSupplies 7201BA OfficeSupplies 7202BA CopierSupplies
4,298.13
4,298.13
395.18 31.50
4,298.13 (395.18) (31.50) $ 3,871.45
(Thiswillbeyourorgtitle)
730RBA ProfessionalServices 7310BA OtherProfessionalServices
36,045.44
2,309.85
38,355.29
5,500.00
5,500.00
38,355.29 5,500.00 (11,000.00) $ 27,355.29
(Thiswillbeyourorg#)
(Thiswillbeyourorgtitle)
740RBA OtherCharges
25,194.00
25,194.00
25,194.00 $ 25,194.00
(Thiswillbeyourorg#)
(Thiswillbeyourorgtitle)
770RBA Travel
3,000.00
3,000.00
3,000.00 $ 3,000.00
