The tables are not directly eDir related, but worth noting
    -- Jeff

-----------------------------------------------------------------------
From: GANS, MITCH 
Sent: Tuesday, February 01, 2005 8:14 AM
To: IS-Everyone
Subject: PS_EMPLOYEE and PS_TENURE Data Warehouse tables Now available in Production

The following tables are now available in Production DB2, loaded nightly for your 
immediate consumption as needed. Please see Don Shrum or Rick McClendon or me with 
any questions or problems.

Mitch
 
***********************************************

CREATE TABLE    FSDBA.PS_TENURE

   (HRMS_ID CHAR(10)                             NOT NULL,
    EFFECTIVE_DATE DATE                          NOT NULL WITH DEFAULT '0001-01-01',
    EXPIRATION_DATE DATE                         NOT NULL WITH DEFAULT '9999-12-31',
    TENURE_STATUS CHAR(1)                        NOT NULL,
    TENURE_DATE DATE                             NOT NULL WITH DEFAULT '0001-01-01',
    TENURE_CIP_CD CHAR(6)                        NOT NULL WITH DEFAULT,
    TENURE_DEPT_CD CHAR(4)                       NOT NULL WITH DEFAULT,
    TENURE_RANK_CD CHAR(5)                       NOT NULL WITH DEFAULT,
    TENURE_RANK_CD CHAR(5)                       NOT NULL WITH DEFAULT,
    TENURE_RANK_DATE DATE                        NOT NULL WITH DEFAULT '0001-01-01'
) IN FSZSYSDB.ZSYSTEN

***************************

CREATE TABLE    FSDBA.PS_EMPLOYEE

   (HRMS_ID CHAR(10)                             NOT NULL,
    PREFIX CHAR(5)                               NOT NULL WITH DEFAULT,
    LAST_NAME CHAR(20)                           NOT NULL WITH DEFAULT,
    FIRST_NAME CHAR(15)                          NOT NULL WITH DEFAULT,
    MIDDLE_INITIAL CHAR(1)                       NOT NULL WITH DEFAULT,
    MIDDLE_NAME CHAR(15)                         NOT NULL WITH DEFAULT,
    SUFFIX CHAR(5)                               NOT NULL WITH DEFAULT,
    EMPLOYEE_ID CHAR(10)                         NOT NULL WITH DEFAULT,
    PERSON_ID CHAR(10)                           NOT NULL WITH DEFAULT,
    ALTERNATE_ID CHAR(6)                         NOT NULL WITH DEFAULT,
    ETHNIC_CD CHAR(1)                            NOT NULL WITH DEFAULT,
    MARITAL_STATUS CHAR(1)                       NOT NULL WITH DEFAULT,
      CONSTRAINT MARITAL_STATUS  CHECK( MARITAL_STATUS IN (' ', 'M', 'S')),
    GENDER CHAR(1)                               NOT NULL WITH DEFAULT
      CONSTRAINT GENDER CHECK( GENDER IN ('M', 'F', ' ')),
    BIRTHDATE DATE         NOT NULL WITH DEFAULT '0001-01-01',
    HIGHEST_DEGREE CHAR(3)                       NOT NULL WITH DEFAULT
    DEGREE_YEAR CHAR(4)                          NOT NULL WITH DEFAULT
    HR_MAJOR_CD CHAR(3)                          NOT NULL WITH DEFAULT
    CITIZEN_CD CHAR(1)                           NOT NULL WITH DEFAULT
    VET_STATUS_CD CHAR(2)                        NOT NULL WITH DEFAULT
    DISABILITY_CD CHAR(5)                        NOT NULL WITH DEFAULT
    SICK_POOL_FL CHAR(1)                         NOT NULL WITH DEFAULT
       CONSTRAINT SICK_POOL_FL CHECK( SICK_POOL_FL IN ('Y', 'N', ' ')),
    AMEX_CARD_FL CHAR(1)                         NOT NULL WITH DEFAULT
       CONSTRAINT AMEX_CARD_FL CHECK( AMEX_CARD_FL IN ('Y', 'N', ' ')),
    STATE_HIRED_DATE DATE                        NOT NULL WITH DEFAULT,
    LAW_ENF_HIRED_DATE DATE NOT NULL WITH DEFAULT '0001-01-01',
    EFT_EXEMPTION_FL CHAR(1)                     NOT NULL WITH DEFAULT
       CONSTRAINT EFT_EXEMPTION_FL CHECK( EFT_EXEMPTION_FL IN ('Y', 'N', ' ', 'G', 'X')),
    EFT_EXEMPTION_TTLG CHAR(6)                   NOT NULL WITH DEFAULT,
    CRTSY_MAIL_FL CHAR(1)                        NOT NULL WITH DEFAULT,
      CONSTRAINT CRTSY_MAIL_FL CHECK( CRTSY_MAIL_FL IN ('Y', 'N', 'B', 'E', ' ', 'M')),
    INSTITUTION_CD CHAR(6)                       NOT NULL WITH DEFAULT,
    EMPLOYEE_TERM_DATE DATE NOT NULL WITH DEFAULT '0001-01-01',
    RETIREMENT_DATE DATE NOT NULL WITH DEFAULT '0001-01-01',
    REPORT_IND CHAR(1)                           NOT NULL WITH DEFAULT,
    SELECT_IND CHAR(1)                           NOT NULL WITH DEFAULT,
    NICK_NAME CHAR(15)                           NOT NULL WITH DEFAULT,
    NICK_NOT_PRINT_FL CHAR(1)                    NOT NULL WITH DEFAULT
    ) IN FSZSYSDB.ZSYSEMP