FE_MGR_REP_TRAN

(SQL Table)
 Index Back

Reporting Chg Empl Specific

This record is a child of FE_MGR_REP_DATand is used to store emplpoyee specific information about each employee contained in a FED SS Reporting Change Transaction

  • Parent record: HR_MGR_REP_DAT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TRANSACTION_NBR Number(15,0) DECIMAL(15) NOT NULL 08/02/99 NAS: Changed the size of this field from 10 to 15. Based on Jim Hillman's decision to make the field at a standard size.
    2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
    4 JOB_DESCR_SS Character(30) VARCHAR2(30) NOT NULL Job Title
    5 POSITION_FLAG Character(1) VARCHAR2(1) NOT NULL Position Flag
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: Y

    6 FE_SS_STAT_IND Character(1) VARCHAR2(1) NOT NULL Used on "_DAT" records for 8.3 eFed Workflow Enhancements
    A=Administrator Action Required
    B=CI failed - Errors & Warnings
    C=Cancelled
    D=Denied
    E=Error with CI or Appr Chain
    I=In Approval Process
    M=Manually Entered into PAR
    P=Automatically Sent to PAR
    S=Completed
    W=Warnings Encountered
    7 FE_SS_FUTURE_FLAG Character(1) VARCHAR2(1) NOT NULL Future Flag

    Y/N Table Edit

    8 MANUAL_UPD_USERID Character(30) VARCHAR2(30) NOT NULL Used on "_DAT" records for 8.3 Workflow Enhancements
    9 MANUAL_UPD_DTTM DateTime(26) TIMESTAMP Used on "_DAT" records for 8.3 Workflow Enhancements