STD_FREQ_TBL_VW

(SQL View)
Index Back

Pay Frequency View

This record gives the view of the Frequency Table for standard pay frequency.

SELECT A.FREQUENCY_ID ,A.EFFDT ,A.EFF_STATUS ,A.DESCR50 ,A.DESCRSHORT ,A.FREQUENCY_TYPE ,A.MAINT_RESPONSBLTY ,A.FREQ_ANNUAL_FACTOR ,A.USE_STD_HOURS_SW FROM PS_FREQUENCY_TBL A WHERE A.FREQUENCY_TYPE IN ('A', 'B', 'D', 'M', 'Q', 'S', 'W')

  • Related Language Record: STD_FREQ_VW_LNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 FREQUENCY_ID Character(5) VARCHAR2(5) NOT NULL Defines a frequency and a set of parameters used for frequency conversion. Typically, these frequencies reflect how often an event occurs. Some examples are compensation frequency and pay frequency.
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %Date

    3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    4 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    6 FREQUENCY_TYPE Character(1) VARCHAR2(1) NOT NULL Indicates the type of a frequency ID.
    A=Annual
    B=Biweekly
    C=Contract
    D=Daily
    F=Every Four Weeks
    H=Hourly
    M=Monthly
    Q=Quarterly
    S=Semimonthly
    W=Weekly
    7 MAINT_RESPONSBLTY Character(1) VARCHAR2(1) NOT NULL Maintenance Responsibility
    C=Customer
    P=PeopleSoft

    Default Value: C

    8 FREQ_ANNUAL_FACTOR Number(12,7) DECIMAL(11,7) NOT NULL Specifies the factor used for annualization/deannualization in a frequency conversion. The Frequency Annualization Factor is expressed in times per year.
    9 USE_STD_HOURS_SW Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether Standard Hours are used for annualization, or the Frequency Annualization Factor associated with the frequency is used for annualization.

    Y/N Table Edit

    Default Value: N