Database Tables
Tforms
System Wide
Miscellaneous
Users
200

The allocation table

What is ap06t?

200

Tform action for brand new employee who has never been on the system before

What is a 1A?

200

The five types of extended leave

What are covid leave, military leave, extended sick, family leave, and parental leave?

200

True or False: In Global security, functions can have more than one security class.

What is false?
200

This user group is the only user group who can update the codes table for codes not equal to ledger earnings

Admin Programmers (us!)

400

A -811 sql error code

What is a duplicate row?

400

Reinstatement tform for 2 year signup used for every employee continuing on the payroll

What is a 2A?

400

The frequency in which the Employee Status Update is run.

What is nightly Monday - Friday?

400

This program auto generates an email for systems to set up a members computer access.

What is Addresses and Personal Info?

400

Compops phone extension

What is 3949?

600
A table must be this to add a non-defaulted primary key to the primary key identifier.

What is empty?

600

The description for a 4Q.

What is Termination - Retirement?

600
The four statuses an employee of the NYS Assembly can have.

What are active, inactive, on leave, and member?

600

The max amount of time an employee can go on leave without pay.

There is none. However, after one year on LWOP many benefits are discontinued. While on LWOP, in order to keep your benefits, you must pay the premium that typically comes out of your paycheck.

600

The manager of application development.

Who is Jami Keith?

800

On a database table, these prevent you from inserting two rows of similar data.

What are primary keys?

800

Payrolled and Noted are the statuses of tforms that have been this.

What is certified?

800

The form/program used to process a check return.

What is AC230? (similarly named to AC340 but not to be confused)

800

Name at least 2 programs that are duplicated in Personnel and Time and Attendance via a copy script.

What are Assignment History, Addresses, Benefit Tform Report/Employee Tform Summary, Current Supervisors and Timesigners, Personnel Search, Pay Periods Time Periods and Session Dates, Units?


800

The three employees who can cert a tform

Who are Amy Marchand, Tracey Wilson, and Audrey McHugh?

1000
In a .sql file, these characters can be used for commenting out lines of code. Provide the ways for single like comment and multi line comment.

What are -- abc for single line 

and 

(= 

abc 

=) for multi line?

1000

This tform action code auto certifies upon approval.

What are action code 5 non-financial tforms?

1000

There are still this many units submitting paper timesheets?

What is 14?

1000

This can cause an employee's 5 day deferral to be paid out at higher than 5 times their daily rate.

What is if they paid in at a higher salary than they left?
1000

This employee used to work for Ways and Means and is now the director of a department.

Who is Audra Nowosielski?

M
e
n
u