POS_T_SPAN_TBL

(SQL Table)
Index Back

Position Time Spans

Position Time Spans Definition Header Table. Used for Time Period defintions.

  • Related Language Record: POS_T_SPAN_LNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 TIME_SET Character(10) VARCHAR2(10) NOT NULL A unique key identifier that represents a time horizon definition dataset.

    Prompt Table: POS_TIME_SET_VW

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 VERSION_NUMBER Number(5,0) INTEGER NOT NULL Represents the Tools version number of a given position tree object.