User Tools

Site Tools


business:position_records

Position Records File Layout

This file layout is used to import position records or distribution records into the position management tables.

Position Records:

Field Length Type Description
Cyr Nyr Flg1CharacterC, N
Pos Nbr13Character
Billet Nbr5Character
Pos Typ1CharacterP, S
Pos Descr30Character
Pos Stat1Character
Pos Sch Yr4Character
Pay Freq1CharacterIf cyr_nyr_flg = C, then 4, 5, or 6. If cyr_nyr_flg = N, then D, E, or F.
Occ Emp Nbr6Character
Prim Job1CharacterY, N
Incr Elig1CharacterY, N
Occ Pay Grd3Character
Occ Pay Stp2Character
Occ Pay Sched1Character
St Stp2Character
Contr Dt Beg8CharacterYYYYMMDD
Contr Dt End8CharacterYYYYMMDD
Dt Payoff8CharacterYYYYMMDD
Nbr Days Off6 (1 digit to right of decimal)Numeric
Act Hrly Dly Rate8 (3 digits to right of decimal)Numeric
Sal Amt10 (2 digits to right of decimal)Numeric
Nbr Remain Pymts3 (0 digits to right of decimal)Numeric
Job Categ5Character
Suppl Atch1CharacterY, N
Job Cd4Character
Frst Paydt Cd3Character
Cal Cd2Character
Campus ID3Character
Dept1Character
Hrs Per Day6 (3 digits to right of decimal)Numeric
Day Empld Pct4 (2 digits to right of decimal)Numeric
Pct Of Yr4 (2 digits to right of decimal)Numeric
Trs Pos Cd2Character
Max Days6 (1 digit to right of decimal)Numeric
Max Pymts3 (0 digits to right of decimal)Numeric
Ovtm Elig Flg1CharacterY, N
St Min Days3 (0 digits to right of decimal)Numeric
Spvsr Pos Nbr13Character
Spvsr Billet Nbr5Character
Suppl Extra Days4 (1 digit to right of decimal)Numeric
Suppl To Pos Nbr13Character
Supple to Pos Billet5Character
Extra Duty Cd2Character
Suppl Typ1Character
Suppl Max Amt8 (2 digits to right of decimal)Numeric
Bas Suppl on Dly Rate1CharacterY, N
Suppl Pay 1time1CharacterY, N
Dt Suppl 1time8CharacterYYYYMMDD
Acpt Chg1CharacterY, N
Dt Create Updt8CharacterYYYYMMDD
Dt Fill8CharacterYYYYMMDD
Fill Pos Rsn8Character
Dt Criteria8CharacterYYYYMMDD
Dt Auth8CharacterYYYYMMDD
Dt Auth End8CharacterYYYYMMDD
Dt Entry8CharacterYYYYMMDD
Dt Inactv8CharacterYYYYMMDD
Inactv Rsn Cd2Character
Vac Rsn2Character
Pay Grd3Character
Pay Stp2Character
Pay Sched1Character
Equiv Unts6 (4 digits to right of decimal)Numeric
Midpnt Bas1Character D, N, X
Pct Of Midpnt6 ( 4 digits to right of decimal)Numeric
Unemp Elig Flg1CharacterY, N
Fica Elig1CharacterM, N, Y
Trs Stat Cd1Character
Bud Amt10(2 digits to right of decimal)Numeric
Bud Sal Ovrrid1CharacterY, N
Act Bud Ind1CharacterY, N

Distribution Records:

Field Length Type Description
Cyr Nyr Flg1CharacterC, N
Pos Nbr13Character
Billet Nbr5Character
Pos Typ1CharacterP, S
Distr Seq3 (0 digits to right of decimal)Numeric
Pay Freq1CharacterIf cyr_nyr_flg = C, then 4, 5, or 6.

If cyr_nyr_flg = N, then D, E, or F.
Job Cd4Character
Acct Typ1CharacterB,G,S,T
Pay Acty2Character
Fund3Character
Func2Character
Obj4Character
Sobj2Character
Org3Character
Fscl Yr1Character
Pgm2Character
Ed Span1Character
Proj Dtl2Character
Acct Amt10 (2 digits to right of decimal)Numeric
Acct Pct8 (5 digits to right of decimal)Numeric
Extra Duty Cd2Character
Expense 3731CharacterY, N
Contrib Acct Flg1CharacterY, N

Notes:

If importing current year records, you must be logged on to a current year pay frequency.

If importing forecast records, you must be logged on to a next year pay frequency.

The file type is comma-separated file.

Use the PMIS User Created report to export the correct file structure and columns.

Leading zeros are required. For example, if the job code is 0204, then the file should have 0204 not 204.

Amount columns that have decimal values should include the decimal point in the column. For example, if the amount is 210, then the file should have 210.00 not 2.10.

business/position_records.txt ยท Last modified: 2018/07/24 12:21 (external edit)

Americans with Disabilities Act (ADA) and Web Accessibility

The Texas Computer Cooperative (TCC) is committed to making its websites accessible to all users. It is TCC policy to ensure that new and updated content complies with Web Content Accessibility Guidelines (WCAG) 2.0 Level AA. We welcome comments and suggestions to improve the accessibility of our websites. If the format of any material on our website interferes with your ability to access the information, use this form to leave a comment about the accessibility of our website.