COUNTRYPrompt Table: COUNTRY_TBL
Default Value: D
Prompt Table: FREQUENCY_TBL
Default Value: W
Prompt Table: FREQUENCY_TBL
Default Value: M
Prompt Table: FREQUENCY_TBL
Default Value: A
Prompt Table: COMP_FREQ_VW
DFLT_FREQUENCY(SQL Table) |
Index Back |
|---|---|
Default Frequency for JOBThis record stores nominated frequencies to be displayed on JOB_DATA_3 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COUNTRY |
Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: COUNTRY_TBL |
| 2 | PAY_FREQ_01 | Character(5) | VARCHAR2(5) NOT NULL |
Instead of hard-coding fixed Frequency type to view salary, this field provides the ability to view pay frequency of client choice
Default Value: D Prompt Table: FREQUENCY_TBL |
| 3 | PAY_FREQ_02 | Character(5) | VARCHAR2(5) NOT NULL |
Instead of hard-coding fixed Frequency type to view salary, this field provides the ability to view pay frequency of client choice
Default Value: W Prompt Table: FREQUENCY_TBL |
| 4 | PAY_FREQ_03 | Character(5) | VARCHAR2(5) NOT NULL |
Instead of hard-coding fixed Frequency type to view salary, this field provides the ability to view pay frequency of client choice
Default Value: M Prompt Table: FREQUENCY_TBL |
| 5 | PAY_FREQ_04 | Character(5) | VARCHAR2(5) NOT NULL |
Instead of hard-coding fixed Frequency type to view salary, this field provides the ability to view pay frequency of client choice
Default Value: A Prompt Table: COMP_FREQ_VW |