PY_MOD_FRQ_L_VW(SQL View) |
Index Back |
---|---|
Rel. Lang. for PY_MOD_PYFRQ_VWA view of the Frequency Table used in paycheck modeling that specifies the frequencies valid for the Comp Frequency. |
SELECT DISTINCT A.FREQUENCY_ID , B.LANGUAGE_CD , B.DESCRSHORT , B.DESCR50 FROM PS_FREQUENCY_TBL A , PS_FREQ_TBL_LANG B WHERE A.FREQUENCY_ID = B.FREQUENCY_ID AND A.EFFDT = B.EFFDT AND A.EFF_STATUS = 'A' AND (A.FREQUENCY_TYPE <> 'H' OR (A.FREQUENCY_TYPE = 'H' AND A.USE_STD_HOURS_SW = 'Y')) AND A.EFFDT = ( SELECT MAX(A_ED.EFFDT) FROM PS_FREQUENCY_TBL A_ED WHERE A_ED.FREQUENCY_ID = A.FREQUENCY_ID AND A_ED.EFFDT <= %CurrentDateIn) |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | COMP_FREQUENCY | Character(5) | VARCHAR2(5) NOT NULL |
Compensation Frequency
A=Annual B=Biweekly C=Contract D=Daily H=Hourly M=Monthly S=Semimonthly W=Weekly |
2 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
3 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
4 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |