FO_WC_JOB_RT_VW(SQL View) |
Index Back |
|---|---|
Assignment -WC Base Rates,TypeDesgined for query to use in Crystal |
| SELECT K.FO_WC_RATE_TYPE , K.FO_WC_BASE_RT ,K.COMPANY ,K.STATE ,K.COUNTRY ,R.JOBCODE ,R.SETID FROM PS_FO_WC_CO_ST_RT K , PS_FO_JOBCODE_WC R WHERE %EffdtCheck(FO_WC_CO_ST_RT K_ED,K,%CurrentDateIn) AND R.COUNTRY = K.COUNTRY AND R.STATE = K.STATE AND K.FO_WC_CODE = R.FO_WC_CODE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FO_WC_RATE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Rate Type
H=Per Hour P=Percentage |
| 2 | FO_WC_BASE_RT | Number(9,5) | DECIMAL(8,5) NOT NULL | Base Rate |
| 3 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 4 | STATE | Character(6) | VARCHAR2(6) NOT NULL | State |
| 5 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 6 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL | Job Code |
| 7 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |