FT_SAL_FREQ_VW

(SQL View)
 Index Back

SELECT DISTINCT STG.FT_RUN_ID , STG.COMP_FREQUENCY , FREQ.DESCR50 FROM %Table(FT_SALARY_STG) STG , %Table(FREQUENCY_TBL) FREQ WHERE STG.COMP_FREQUENCY = FREQ.FREQUENCY_ID AND %EffdtCheck(FREQUENCY_TBL FREQ2, FREQ, %CurrentDateIn) AND FREQ.EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 FT_RUN_ID Number(18,0) DECIMAL(18) NOT NULL LEGAL_ENTITY_ID
2 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
3 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50