SCH_DEFN_ROTAVW

(SQL View)
Index Back

Schedule Definition Table

View of Schedule Rotation table switching order of Rotation ID and Eff date for use when prompting for valid rotations.

SELECT SETID , SCHEDULE_ID , ROTATION_ID , EFFDT , ROTATION_START_DAY , EFF_STATUS FROM PS_SCH_DEFN_ROTATN WHERE SCH_ADHOC_IND = '1'

  • Parent record: SCH_DEFN_TBL
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SET_VLD_TL_01

    2 ALT_WRK_SCHED_ID Character(16) VARCHAR2(16) NOT NULL TR Alternate Schedule ID
    3 ROTATION_ID Character(10) VARCHAR2(10) NOT NULL Rotation ID

    Default Value: 1

    4 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    5 ROTATION_START_DAY Number(3,0) SMALLINT NOT NULL Relative Day Number of a Rotation. This represents the Day Number scheduled for the rotation on the Effective Date of the Schedule.

    Default Value: 1

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

    Default Value: A