TL_PAYSYS_TBL(SQL Table) |
Index Back |
---|---|
Time & Labor Pay System TblSetup for the pay systems used by the customer, along with the options defined if the customer wants labor distribution and labor dilution performed on the costs being retrieved from the payroll system. In addition, if the user wants labor distribution to be performed, they can provide the percentages back to Time and Labor, as they want to define the breakout of costs to the original time entered. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PAY_SYSTEM | Character(4) | VARCHAR2(4) NOT NULL |
Payroll System
GP=Global Payroll NA=Payroll for North America |
2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
3 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL |
Short Description
Default Value: TL_PAYSYS_TBL.DESCR |
4 | LD_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Labor Distribution Used
Y/N Table Edit Default Value: Y |
5 | LDILU_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Labor Dilution Used
Y/N Table Edit Default Value: Y |