Interfaces

User Tools

Site Tools

Trace:
business:position_records

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision		Previous revision
business:position_records [2018/07/24 18:21] – external edit 127.0.0.1business:position_records [2022/09/30 15:32] (current) – external edit 127.0.0.1
Line 2: Line 2:
  
 <WRAP round intro> <WRAP round intro>
-This file layout is used to import position records or distribution records into the position management tables.+The Import Position Records page is used to import position records or distribution records into the position management tables. When importing position records, ensure the payroll frequency of the archived file is the same as that of the logged-on payroll frequency.  
 + 
 +**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. 
 +  * 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.
 </WRAP> </WRAP>
  
-**Position Records**: +===== Position Records: ===== 
 + 
  
-^Field ^Length ^Type ^Description ^ +All fields with a Y in the 2nd column is required on every file upload.
-|Cyr Nyr Flg|1|Character|C, N| +
-|Pos Nbr|13|Character| |  +
-|Billet Nbr|5|Character| |  +
-|Pos Typ|1|Character|P, S| +
-|Pos Descr|30|Character| |  +
-|Pos Stat|1|Character| |  +
-|Pos Sch Yr|4|Character| |  +
-|Pay Freq|1|Character|If cyr_nyr_flg = C, then 4, 5, or 6.  If cyr_nyr_flg = N, then D, E, or F.| +
-|Occ Emp Nbr|6|Character| |  +
-|Prim Job|1|Character|Y, N| +
-|Incr Elig|1|Character|Y, N| +
-|Occ Pay Grd|3|Character| |  +
-|Occ Pay Stp|2|Character| |  +
-|Occ Pay Sched|1|Character| |  +
-|St Stp|2|Character| |  +
-|Contr Dt Beg|8|Character|YYYYMMDD| +
-|Contr Dt End|8|Character|YYYYMMDD| +
-|Dt Payoff|8|Character|YYYYMMDD| +
-|Nbr Days Off|6 (1 digit to right of decimal)|Numeric| |  +
-|Act Hrly Dly Rate|8 (3 digits to right of decimal)|Numeric| |  +
-|Sal Amt|10 (2 digits to right of decimal)|Numeric| |  +
-|Nbr Remain Pymts|3 (0 digits to right of decimal)|Numeric| |  +
-|Job Categ|5|Character| |  +
-|Suppl Atch|1|Character|Y, N| +
-|Job Cd|4|Character| |  +
-|Frst Paydt Cd|3|Character| |  +
-|Cal Cd|2|Character| |  +
-|Campus ID|3|Character| |  +
-|Dept|1|Character| |  +
-|Hrs Per Day|6 (3 digits to right of decimal)|Numeric| |  +
-|Day Empld Pct|4 (2 digits to right of decimal)|Numeric| |  +
-|Pct Of Yr|4 (2 digits to right of decimal)|Numeric| |  +
-|Trs Pos Cd|2|Character| |  +
-|Max Days|6 (1 digit to right of decimal)|Numeric| |  +
-|Max Pymts|3 (0 digits to right of decimal)|Numeric| |  +
-|Ovtm Elig Flg|1|Character|Y, N| +
-|St Min Days|3 (0 digits to right of decimal)|Numeric| |  +
-|Spvsr Pos Nbr|13|Character| |  +
-|Spvsr Billet Nbr|5|Character| |  +
-|Suppl Extra Days|4 (1 digit to right of decimal)|Numeric| |  +
-|Suppl To Pos Nbr|13|Character| |  +
-|Supple to Pos Billet|5|Character| |  +
-|Extra Duty Cd|2|Character| |  +
-|Suppl Typ|1|Character| |  +
-|Suppl Max Amt|8 (2 digits to right of decimal)|Numeric| |  +
-|Bas Suppl on Dly Rate|1|Character|Y, N|  +
-|Suppl Pay 1time|1|Character|Y, N| +
-|Dt Suppl 1time|8|Character|YYYYMMDD| +
-|Acpt Chg|1|Character|Y, N| +
-|Dt Create Updt|8|Character|YYYYMMDD| +
-|Dt Fill|8|Character|YYYYMMDD| +
-|Fill Pos Rsn|8|Character| |  +
-|Dt Criteria|8|Character|YYYYMMDD| +
-|Dt Auth|8|Character|YYYYMMDD| +
-|Dt Auth End|8|Character|YYYYMMDD| +
-|Dt Entry|8|Character|YYYYMMDD| +
-|Dt Inactv|8|Character|YYYYMMDD| +
-|Inactv Rsn Cd|2|Character| |  +
-|Vac Rsn|2|Character| |  +
-|Pay Grd|3|Character| |  +
-|Pay Stp|2|Character| |  +
-|Pay Sched|1|Character| | +
-|Equiv Unts|6 (4 digits to right of decimal)|Numeric|  +
-|Midpnt Bas|1|Character D, N, X|  +
-|Pct Of Midpnt|6 ( 4 digits to right of decimal)|Numeric|  +
-|Unemp Elig Flg|1|Character|Y, N| +
-|Fica Elig|1|Character|M, N, Y| +
-|Trs Stat Cd|1|Character|  +
-|Bud Amt|10(2 digits to right of decimal)|Numeric|  +
-|Bud Sal Ovrrid|1|Character|Y, N| +
-|Act Bud Ind|1|Character|Y, N|+
  
-**Distribution Records**:+Fields with an S in the 2nd column are only required if the position is filled (it is staff specific information).
  
-^Field ^Length ^Type ^Description ^ 
-|Cyr Nyr Flg|1|Character|C, N|  
-|Pos Nbr|13|Character| |  
-|Billet Nbr|5|Character| |  
-|Pos Typ|1|Character|P, S| 
-|Distr Seq|3 (0 digits to right of decimal)|Numeric| |  
-|Pay Freq|1|Character|If cyr_nyr_flg = C, then 4, 5, or 6.\\ \\  If cyr_nyr_flg = N, then D, E, or F.| 
-|Job Cd|4|Character| |  
-|Acct Typ|1|Character|B,G,S,T| 
-|Pay Acty|2|Character|  
-|Fund|3|Character| |  
-|Func|2|Character| |  
-|Obj|4|Character| |  
-|Sobj|2|Character| |  
-|Org|3|Character| |  
-|Fscl Yr|1|Character| |  
-|Pgm|2|Character| |  
-|Ed Span|1|Character| |  
-|Proj Dtl|2|Character| |  
-|Acct Amt|10 (2 digits to right of decimal)|Numeric| |  
-|Acct Pct|8 (5 digits to right of decimal)|Numeric| |  
-|Extra Duty Cd|2|Character| |  
-|Expense 373|1|Character|Y, N| 
-|Contrib Acct Flg|1|Character|Y, N| 
  
-<WRAP Box> +^Field/Column^Req^Position Type ^Data Type^Max Length (including decimal) ^Expected Value^ Notes^ 
-**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. +|Cyr Nyr Flg|Y|P / S|Character|1 |C, N| 
-</WRAP>+|Pos Nbr|Y|P / S|Character|13|  | 
 +|Billet Nbr|Y|P / S|Character|5|  | 
 +|Pos Typ|Y|P / S|Character|1|P (regular)\\  S (supplement, extra duty, stipend)|  
 +|Pos Descr| |P / S|Character|30| | 
 +|Pos Stat|  |P / S|Character|1|  | 
 +|Pos Sch Yr|  |P / S|Character|4| 
 +|Pay Freq|  |P / S|Character|1|If current year (C), then 4, 5, or 6.\\  If next year (N), then D, E, or F.| 
 +|Occ Emp Nbr|S|P / S|Character|6| |Only required for filled positions.| 
 +|Prim Job|S|P|Character|1|Y,N|Only required for filled positions.\\  Each employee can only have 1 position as primary.| 
 +|Incr Elig|S|P|Character|1|Y,N|Only required for filled positions.| 
 +|Occ Pay Grd|S|P|Character|3| |Only required for filled positions.| 
 +|Occ Pay Stp|S|P|Character|2|  |Only required for filled positions.| 
 +|Occ Pay Sched|S|P|Character|1| |Only required for filled positions.| 
 +|St Stp|S|P|Characer|2| |Only required for filled positions.| 
 +|Contr Dt Beg|S|P|Character|8|YYYYMMDD|Only required for filled positions.| 
 +|Contr Dt End|S|P|Character|8|YYYYMMDD|Only required for filled positions.| 
 +|Dt Payoff|S|P|Character|8|YYYYMMDD|Only required for filled positions.| 
 +|Nbr Days Off|S|P|Numeric|6 (1 digit to right of decimal)| | 
 +|Act Hrly Dly Rate|S|P|Numeric|8 (3 digits to right of decimal)| |Only required for filled positions.| 
 +|Sal Amt|S|P|Numeric|10 (2 digits to right of decimal)| |Only required for filled positions.| 
 +|Nbr Remain Pymts|S|P / S|Numeric|3 (0 digits to right of decimal)| |Only required for filled positions.| 
 +|Job Categ| |P / S|Character|5| | | 
 +|Suppl Atch| |P|Character|1|Y,N|Set to N and simulation will update.| 
 +|Job Cd| |P|Character|4| | | 
 +|Frst Paydt Cd| |P|Character|3| | | 
 +|Cal Cd| | P|Character|2|  | 
 +|Campus Id| |P / S|Character|3| | | 
 +|Dept| |P / S|Character|1| | 
 +|Hrs Per Day| |P|Numeric|6 (3 digits to right of decimal)| | 
 +|Day Empld Pct| |P|Numeric|4 (2 digits to right of decimal)|  | 
 +|Pct Of Yr| |P|Numeric|4 (2 digits to right of decimal)| |  
 +|Trs Pos Cd| |P|Character|2|  |  
 +|Max Days| |P / S|Numeric|6 (1 digit to right of decimal)|  
 +|Max Pymts| |P / S|Numeric|3 (0 digits to right of decimal)|  
 +|Ovtm Elig Flg|  |P|Character|1|Y,N| |  
 +|St Min Days| |P|Numeric|3 (0 digits to right of decimal)|  
 +|Spvsr Pos Nbr| |P|Character|13| |Not required| 
 +|Spvsr Billet Nbr| |P|Character|5| |Not required| 
 +|Suppl Extra Days| |S|Numeric|4 (1 digit to right of decimal)| 
 +|Suppl To Pos Nbr|  |S|Character|13| |Position number of the “full time” job to attach this supplement to (required for extra days)| 
 +|Suppl To Pos Billet| |S|Character|5| |Billet number of the “full time” job to attach this supplement to (required for extra days)| 
 +|Extra Duty Cd| |S|Character|2| | 
 +|Suppl Typ | |S|Character|1| G, S, B, T| | 
 +|Suppl Max Amt | |S|Numeric|8 (2 digits to right of decimal)| | 
 +|Bas Suppl On Dly Rate| |S|Character|1|Y,N| | 
 +|Suppl Pay 1time| |S|Character|1|Y,N|  |  
 +|Dt Suppl 1time| |S|Character|8|YYYYMMDD| |  
 +|Acpt Chg| |P / S|Character|1|Y,N|Set to Y|  
 +|Dt Create Updt| |P / S|Character|8|YYYYMMDD|Not required – will default| 
 +|Dt Fill| |P / S|Character|8|YYYYMMDD|Not required – will default| 
 +|Fill Pos Rsn| |P / S|Character|2| | 
 +|Dt Criteria| |P / S|Character|8|YYYYMMDD|Not required| 
 +|Dt Auth|  |P / S|Character|8|YYYYMMDD|Not required| 
 +|Dt Auth End| |P / S|Character|8|YYYYMMDD|Not required| 
 +|Dt Entry|  |P / S|Character|8|YYYYMMDD|Not required| 
 +|Dt Inactv| |P / S|Character|8|YYYYMMDD|Not required| 
 +|Inactv Rsn Cd| |P / S|Character|2|  | | 
 +|Vac Rsn| |P / S|Character|2|  |  | 
 +|Pay Grd| |P|Character|3| |“budgeting” pay grade| 
 +|Pay Stp|  |P|Character|2|  |“budgeting” pay step| 
 +|Pay Sched|  |P|Character|1| |“budgeting” pay scheduling| 
 +|Equiv Unts| |P|Numeric|6 (4 digits to right of decimal)| |   
 +|Midpnt Bas| |P|Character|1|D = midpoint, or N = minimum, or X = maximum|“budgeting” on scale| 
 +|Pct Of Midpnt| |P|Numeric|6 (4 digits to right of decimal)| |“budgeting” extra percentage (can be 0)| 
 +|Unemp Elig Flg| |P|Character|1|Y,N| | 
 +|Fica Elig| |P|Character|1|M,N,Y|  | 
 +|Trs Stat Cd| |P|Character|1| | | 
 +|Bud Amt| |P / S|Numeric|10 (2 digits to right of decimal)| |Can be 0 as simulation will update| 
 +|Bud Sal Ovrrid| |P / S|Character|1|Y,N|Set to N| 
 +|Act Bud Ind| |P / S|Character|1|Y,N|Set to Y| 
 + 
 + 
 +  
 +=====Distribution Records:===== 
 + 
 +All fields with a Y in the 2nd column is required on every file upload. 
 + 
 +Fields with an S in the 2nd column are only required if the position is filled (it is staff specific information). 
 + 
 +^Field/Column^Req^Position Type ^Data Type^Max Length (including decimal) ^Expected Value^ Notes^ 
 +|Cyr Nyr Flg|Y|P / S|Character|1|C,N| 
 +|Pos Nbr|Y|P / S|Character|13|  |  
 +|Billet Nbr|Y|P / S|Character|5| |  
 +|Pos Typ|Y|P / S|Character|1|P,S| |  
 +|Distr Seq|Y|P / S|Numeric|3 (0 digits to right of decimal)| | | 
 +|Pay Freq|Y|P / S|Character|1 If cyr_nyr_flg = C, then 4, 5, or 6.\\  If cyr_nyr_flg = N, then D, E, or F.| | 
 +|Job Cd|Y|P / S|Character|4| | | 
 +|Acct Typ|Y|P / S|Character|1|B,G,S,T| | 
 +|Pay Acty|Y|P / S|Character|2| | |  
 +|Fund|Y|P / S|Character|3| | |  
 +|Func|Y|P / S|Character|2| | |  
 +|Obj|Y|P / S|Character|4| | |  
 +|Sobj|Y|P / S|Character|2| | |  
 +|Org|Y|P / S|Character|3| | |  
 +|Fscl Yr|Y|P / S|Character|1| | | 
 +|Pgm|Y|P / S|Character|2| | |  
 +|Ed Span|Y|P / S|Character|1| | |  
 +|Proj Dtl|Y|P / S|Character|2| | |  
 +|Acct Amt|Y|P / S|Character|10 (2 digits to right of decimal)| |  
 +|Acct Pct|Y|P / S|Numeric|8 (5 digits to right of decimal)| |  
 +|Extra Duty Cd|Y|P / S|Numeric|2|(if applicable)| |  
 +|Expense 373|Y|P / S|Character|1|Y,N| |  
 +|Contrib Acct Flg|Y|P / S|Character|1|Y,N| |
business/position_records.1532456492.txt.gz · Last modified: 2018/07/24 13:21 (external edit)

Page Tools

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International

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.