FT_RUN_IDCOMP_FREQUENCYA=Annual
B=Biweekly
C=Contract
D=Daily
H=Hourly
M=Monthly
S=Semimonthly
W=Weekly
CURRENCY_CDFT_SAL_AUD_VW(SQL View) |
Index Back |
|---|---|
View used for Fusion Coex CWBView used for Fusion Coex CWB |
| SELECT FT_RUN_ID , COMP_FREQUENCY , CURRENCY_CD FROM PS_FT_SALARY_STG GROUP BY FT_RUN_ID , COMP_FREQUENCY , CURRENCY_CD |
| # | 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 | CURRENCY_CD |
Character(3) | VARCHAR2(3) NOT NULL | Currency Code |