GP Tables

SV00801 - SV_Labor_Load_Annual_Schedule

SQL Query Builder

95 Columns

Column Description Type Length
Technician char(11)
CUSTNMBR char(15)
LOCATNNM char(31)
Contract_Number char(11)
WSCONTSQ int
Burden_Hrs_Jan int
Burden_Hrs_Feb int
Burden_Hrs_Mar int
Burden_Hrs_Apr int
Burden_Hrs_May int
Burden_Hrs_Jun int
Burden_Hrs_Jul int
Burden_Hrs_Aug int
Burden_Hrs_Sep int
Burden_Hrs_Oct int
Burden_Hrs_Nov int
Burden_Hrs_Dec int
Available_MCC_Hours_Jan int
Available_MCC_Hours_Feb int
Available_MCC_Hours_Mar int
Available_MCC_Hours_Apr int
Available_MCC_Hours_May int
Available_MCC_Hours_Jun int
Available_MCC_Hours_Jul int
Available_MCC_Hours_Aug int
Available_MCC_Hours_Sep int
Available_MCC_Hours_Oct int
Available_MCC_Hours_Nov int
Available_MCC_Hours_Dec int
MC_Hours_Jan int
MC_Hours_Feb int
MC_Hours_Mar int
MC_Hours_Apr int
MC_Hours_May int
MC_Hours_Jun int
MC_Hours_Jul int
MC_Hours_Aug int
MC_Hours_Sep int
MC_Hours_Oct int
MC_Hours_Nov int
MC_Hours_Dec int
Est_Billable_Hours_Jan int
Est_Billable_Hours_Feb int
Est_Billable_Hours_Mar int
Est_Billable_Hours_Apr int
Est_Billable_Hours_May int
Est_Billable_Hours_Jun int
Est_Billable_Hours_Jul int
Est_Billable_Hours_Aug int
Est_Billable_Hours_Sep int
Est_Billable_Hours_Oct int
Est_Billable_Hours_Nov int
Est_Billable_Hours_Dec int
Jan_Est_Hours int
Feb_Est_Hours int
March_Est_Hours int
April_Est_Hours int
May_Est_Hours int
June_Est_Hours int
July_Est_Hours int
Aug_Est_Hours int
Sept_Est_Hours int
Oct_Est_Hours int
Nov_Est_Hours int
Dec_Est_Hours int
Task_Hours int
Jan_Required tinyint
Feb_Required tinyint
March_Required tinyint
April_Required tinyint
May_Required tinyint
June_Required tinyint
July_Required tinyint
Aug_Required tinyint
Sept_Required tinyint
Oct_Required tinyint
Nov_Required tinyint
Dec_Required tinyint
Total_Hours_Jan int
Total_Hours_Feb int
Total_Hours_Mar int
Total_Hours_Apr int
Total_Hours_May int
Total_Hours_Jun int
Total_Hours_Jul int
Total_Hours_Aug int
Total_Hours_Sep int
Total_Hours_Oct int
Total_Hours_Nov int
Total_Hours_Dec int
Estimate_Hours int
Total_ATS_PM_Hours int
Total_All_Hours int
Standard_Task_Hours int
DEX_ROW_ID int auto number (1,1)

Related Tables

Tables that share columns with SV00801. Click "Join" to add to your query.

DEX_ROW_ID

AAG00200 AAG00201 AAG00202 AAG00300 AAG00301 AAG00302 ACColumn AF00100

CUSTNMBR

ASIEXP02 ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP15 ASIEXP19 ASIEXP20 ASIEXP21

Contract_Number

SV00053 SV00055 SV00131 SV00132 SV00300 SV00387 SV00400 SV00401

WSCONTSQ

SV00053 SV00131 SV00132 SV00300 SV00403 SV00500 SV00501 SV00502

Technician

SV00101 SV00114 SV00115 SV00118 SV00200 SV00221 SV00300 SV00301

Estimate_Hours

SV00301 SV00302 SV00387 SV00500 SV00501 SV00502 SV00529 SV00534

LOCATNNM

EDCEI002 SY01500 SV00054 SV00055 SV00101 SV00200 SV00300 SV00430

Task_Hours

SV00529 SV00538 SV00545 SV00560 SV00561 SV00582 SV00592

Jan_Required

SV00529 SV00538 SV00541 SV00561 SV585CLP

Feb_Required

SV00529 SV00538 SV00541 SV00561 SV585CLP