HR_SNR_DATE_TBL

(SQL Table)
Index Back

Seniority Date Setup Table

Seniority Dates Setup table for use when defining Labor Agreements.

  • Related Language Record: HR_SNR_DATE_LNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SENIORITY_DATE_ID Character(10) VARCHAR2(10) NOT NULL Seniority Date ID
    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 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    6 SENIORITY_LABEL Character(30) VARCHAR2(30) NOT NULL Seniority Date Label
    7 DEF_DATE_FLG Character(1) VARCHAR2(1) NOT NULL Default from Existing Field

    Y/N Table Edit

    Default Value: N

    8 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

    Prompt Table: HR_SNRRECDFN_VW

    9 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

    Prompt Table: HR_SNRTY_FLDS

    10 DATE_EDIT_FLAG Character(1) VARCHAR2(1) NOT NULL Date Editable Flag

    Y/N Table Edit

    Default Value: N

    11 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

    Default Value: %datetime

    12 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.