FT_POSCHNG_TBL

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
3 EFFDT Date(10) DATE Effective Date

Default Value: %date

4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
5 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
6 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.
7 FT_TLR_EMPL_RCD Number(3,0) SMALLINT NOT NULL Trailing Employee Record Numb
8 FT_TLR_EFFDT Date(10) DATE Trailing Effdt
9 FT_TLR_EFFSEQ Number(3,0) SMALLINT NOT NULL Trailing Effective Sequence
10 FT_POSITION_TLR Character(8) VARCHAR2(8) NOT NULL Position Number
11 FT_LASTUPDDTTM_TLR 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.
12 FT_REQUIRED_FLAG Character(1) VARCHAR2(1) NOT NULL Required Field
N=No
Y=Yes