JOB_USF_CV

(SQL View)
 Index Back

JOB_USF MSG Clairvia

Clone of JOB_USF record for Clairvia Fullsync message

SELECT JOBU.EMPLID , JOBU.EMPL_RCD , EFFDT , EFFSEQ , GVT_EFFDT , GVT_EFFDT_PROPOSED , GVT_TRANS_NBR , GVT_TRANS_NBR_SEQ , GVT_WIP_STATUS , GVT_STATUS_TYPE , GVT_NOA_CODE , GVT_LEG_AUTH_1 , GVT_PAR_AUTH_D1 , GVT_PAR_AUTH_D1_2 , GVT_LEG_AUTH_2 , GVT_PAR_AUTH_D2 , GVT_PAR_AUTH_D2_2 , GVT_PAR_NTE_DATE , GVT_WORK_SCHED , GVT_SUB_AGENCY , GVT_ELIG_FEHB , GVT_FEHB_DT , GVT_PAY_RATE_DETER , GVT_STEP , GVT_RTND_PAY_PLAN , GVT_RTND_SAL_PLAN , GVT_RTND_GRADE , GVT_RTND_STEP , GVT_RTND_GVT_STEP , GVT_PAY_BASIS , GVT_COMPRATE , GVT_LOCALITY_ADJ , GVT_BIWEEKLY_RT , GVT_DAILY_RT , GVT_HRLY_RT_NO_LOC , GVT_DLY_RT_NO_LOC , GVT_BW_RT_NO_LOC , GVT_MNLY_RT_NO_LOC , GVT_ANNL_RT_NO_LOC , GVT_XFER_FROM_AGCY , GVT_XFER_TO_AGCY , GVT_RETIRE_PLAN , GVT_ANN_IND , GVT_FEGLI , GVT_FEGLI_LIVING , GVT_LIVING_AMT , GVT_ANNUITY_OFFSET , GVT_CSRS_FROZN_SVC , GVT_PREV_RET_COVRG , GVT_FERS_COVERAGE , GVT_TYPE_OF_APPT , GVT_POI , GVT_POSN_OCCUPIED , GVT_CONT_EMPLID , GVT_ROUTE_NEXT , GVT_CHANGE_FLAG , GVT_TSP_UPD_IND , GVT_PI_UPD_IND , GVT_SF52_NBR , GVT_S113G_CEILING , GVT_LEO_POSITION , GVT_ANNUIT_COM_DT , GVT_BASIC_LIFE_RED , GVT_DED_PRORT_DT , GVT_FEGLI_BASC_PCT , GVT_FEGLI_OPT_PCT , GVT_FEHB_PCT , GVT_RETRO_FLAG , GVT_RETRO_DED_FLAG , GVT_RETRO_JOB_FLAG , GVT_RETRO_BSE_FLAG , GVT_OTH_PAY_CHG , GVT_DETL_POSN_NBR , ANNL_BEN_BASE_OVRD , BENEFIT_PROGRAM , UPDATE_PAYROLL , GVT_PAY_PLAN , GVT_PAY_FLAG , GVT_NID_CHANGE , GVT_SCD_RETIRE , GVT_SCD_TSP , GVT_SCD_LEO , GVT_SCD_SEVPAY , GVT_SEVPAY_PRV_WKS , GVT_MAND_RET_DT , GVT_WGI_STATUS , GVT_INTRM_DAYS_WGI , GVT_NONPAY_NOA , GVT_NONPAY_HRS_WGI , GVT_NONPAY_HRS_SCD , GVT_NONPAY_HRS_TNR , GVT_NONPAY_HRS_PRB , GVT_TEMP_PRO_EXPIR , GVT_TEMP_PSN_EXPIR , GVT_DETAIL_EXPIRES , GVT_SABBATIC_EXPIR , GVT_RTND_GRADE_BEG , GVT_RTND_GRADE_EXP , GVT_CURR_APT_AUTH1 , GVT_CURR_APT_AUTH2 , GVT_APPT_EXPIR_DT , GVT_CNV_BEGIN_DATE , GVT_CAREER_CNV_DUE , GVT_CAREER_COND_DT , GVT_APPT_LIMIT_HRS , GVT_APPT_LIMIT_DYS , GVT_APPT_LIMIT_AMT , GVT_SUPV_PROB_DT , GVT_SES_PROB_DT , GVT_SEC_CLR_STATUS , GVT_CLRNCE_STAT_DT , GVT_ERN_PGM_PERM , GVT_OCC_SERS_PERM , GVT_GRADE_PERM , GVT_COMP_AREA_PERM , GVT_COMP_LVL_PERM , GVT_SPEP , GVT_WGI_DUE_DATE , GVT_DT_LEI , GVT_FIN_DISCLOSURE , GVT_FIN_DISCL_DATE , GVT_TENURE , GVT_DETL_BARG_UNIT , GVT_DETL_UNION_CD , GVT_WELFARE_WK_CD FROM PS_JOB_USF JOBU , PS_PER_ORG_ASG_INT ASG WHERE ASG.EMPLID = JOBU.EMPLID AND ASG.EMPL_RCD = JOBU.EMPL_RCD AND ASG.INT_APP_TYPE = 'SCH' AND ASG.INTEGR_PROD_CD = 'CV' AND ASG.ENROLLED_FLAG = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Default Value: JOB.EMPLID

Prompt Table: JOB

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

Default Value: JOB.EMPL_RCD

Prompt Table: JOB

3 EFFDT Date(10) DATE Effective Date

Default Value: JOB.EFFDT

4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence

Default Value: JOB.EFFSEQ

5 GVT_EFFDT Date(10) DATE Effective Date
6 GVT_EFFDT_PROPOSED Date(10) DATE Proposed Effective Date

Default Value: %date

7 GVT_TRANS_NBR Number(1,0) SMALLINT NOT NULL Transaction Nbr
8 GVT_TRANS_NBR_SEQ Number(1,0) SMALLINT NOT NULL Transaction Nbr / Seq
9 GVT_WIP_STATUS Character(3) VARCHAR2(3) NOT NULL Work-in-Progress Status
10 GVT_STATUS_TYPE Character(3) VARCHAR2(3) NOT NULL Status Type
CAN=Cancelled
COM=Completed
COR=Corrected
IRR=IRR Reported
WIP=Work-in-progress
11 GVT_NOA_CODE Character(3) VARCHAR2(3) NOT NULL Nature of Action Code
12 GVT_LEG_AUTH_1 Character(3) VARCHAR2(3) NOT NULL Legal Authority (1)
13 GVT_PAR_AUTH_D1 Character(25) VARCHAR2(25) NOT NULL Authority 1 Descr - Part 1
14 GVT_PAR_AUTH_D1_2 Character(25) VARCHAR2(25) NOT NULL Authority 1 Descr - Part 2
15 GVT_LEG_AUTH_2 Character(3) VARCHAR2(3) NOT NULL Legal Authority (2)
16 GVT_PAR_AUTH_D2 Character(25) VARCHAR2(25) NOT NULL Authority 2 Descr - Part 1
17 GVT_PAR_AUTH_D2_2 Character(25) VARCHAR2(25) NOT NULL Authority 2 Descr - Part 2
18 GVT_PAR_NTE_DATE Date(10) DATE Not-to-Exceed Date
19 GVT_WORK_SCHED Character(1) VARCHAR2(1) NOT NULL Work Schedule
B=Baylor Plan
F=Full Time
G=Full Time Seasonal
I=Intermittent
J=Intermittent-Seasonal
P=Part Time
Q=Part-Time Seasonal
R=Part-Time Phased Retiree
S=Part-Time Job Sharer
T=Part-Time Seasonal Job Sharer

Default Value: F

20 GVT_SUB_AGENCY Character(2) VARCHAR2(2) NOT NULL Sub-Agency
21 GVT_ELIG_FEHB Character(3) VARCHAR2(3) NOT NULL Eligible for FEHB
CC=Continuing Coverage
NE=Not Eligible
PER=Permanent
TAP=Temporary Appointment > 1 yr
TSV=Temp Appt < 1yr + FedSvc > 1yr
22 GVT_FEHB_DT Date(10) DATE FEHB Eligibility Date
23 GVT_PAY_RATE_DETER Character(1) VARCHAR2(1) NOT NULL Pay Rate Determinant
0=Regular Rate
2=Saved Rate - Indefinite
3=Retained Pay - Spec Rt Adjust
4=Saved Rate - Other
5=Special & Superior Quals
6=Special Rate
7=Superior Qualifications Rate
A=Retained Grade - Diff Posn
B=Retained Grade - Same Posn
C=Critical Position Pay
E=Rtnd Grd & Spec Rt - Diff Posn
F=Rtnd Grd & Spec Rt - Same Posn
J=Retained Pay - Same Position
K=Retained Pay - Diff Posn
M=Continued IGA Pay
M=Continued IGA Pay
P=Preserved IGA Pay
R=Retained Pay - SES Removal
S=Continued SES Basic Pay
T=Below the Minimum Rate
U=Rtnd Grade & Pay - Same Posn
V=Rtnd Grade & Pay - Diff Posn
Y=NSPS Retained Pay
Z=Border Equalization Allowance

Default Value: 0

24 GVT_STEP Character(2) VARCHAR2(2) NOT NULL US Federal Step
25 GVT_RTND_PAY_PLAN Character(2) VARCHAR2(2) NOT NULL Retained Pay Plan
26 GVT_RTND_SAL_PLAN Character(4) VARCHAR2(4) NOT NULL Retained Pay Table
27 GVT_RTND_GRADE Character(3) VARCHAR2(3) NOT NULL Retained Grade
28 GVT_RTND_STEP Number(2,0) SMALLINT NOT NULL Retained Step
29 GVT_RTND_GVT_STEP Character(2) VARCHAR2(2) NOT NULL Retained US Federal Step
30 GVT_PAY_BASIS Character(2) VARCHAR2(2) NOT NULL Pay Basis
BW=Bi-weekly
FB=Fee Basis
PA=Per Annum
PD=Per Diem
PH=Per Hour
PM=Per Month
PW=Piece Work
SM=Semi-monthly
SY=School Year
WC=Without Compensation

Default Value: PA

31 GVT_COMPRATE Number(19,6) DECIMAL(18,6) NOT NULL Comp Rate
32 GVT_LOCALITY_ADJ Number(8,2) DECIMAL(7,2) NOT NULL Locality Adjustment
33 GVT_BIWEEKLY_RT Number(10,2) DECIMAL(9,2) NOT NULL Biweekly Rate
34 GVT_DAILY_RT Number(10,2) DECIMAL(9,2) NOT NULL Daily Rate
35 GVT_HRLY_RT_NO_LOC Number(19,6) DECIMAL(18,6) NOT NULL Hourly Rate with out Location
36 GVT_DLY_RT_NO_LOC Number(10,2) DECIMAL(9,2) NOT NULL Daily Rate No Locality
37 GVT_BW_RT_NO_LOC Number(10,2) DECIMAL(9,2) NOT NULL No Locality Biweekly Rate
38 GVT_MNLY_RT_NO_LOC Number(19,3) DECIMAL(18,3) NOT NULL No Locality Monthly Rate
39 GVT_ANNL_RT_NO_LOC Number(19,3) DECIMAL(18,3) NOT NULL No Locality Annual Rate
40 GVT_XFER_FROM_AGCY Character(2) VARCHAR2(2) NOT NULL Transferred From Agency
41 GVT_XFER_TO_AGCY Character(2) VARCHAR2(2) NOT NULL Transferred To Agency
42 GVT_RETIRE_PLAN Character(2) VARCHAR2(2) NOT NULL Retirement Plan

Default Value: K

43 GVT_ANN_IND Character(1) VARCHAR2(1) NOT NULL Annuitant Indicator
1=Reempl Ann-CS
2=Ret Officer
3=Ret Enlisted
4=Ret Off/Reempl Ann-CS
5=Ret Enl/Reempl Ann-CS
6=CS-No Reduction
7=Ret Off/CS-No Reduc
8=Ret Enl/CS-No Reduc
9=Not Applicable
A=Reempl Ann-FE
B=Former Ann-FE
C=Ret Off/Reempl Ann-FE
D=Ret Off/Former Ann-FE
E=Ret Enl/Reempl Ann-FE
F=Ret Enl/Former Ann-FE
G=FE - No Reduction
H=Ret Off/FE-No Reduc
J=Ret Enl/FE-No Reduc
M=Former FERS Phased Retiree
N=FERS Phased Retiree Officer
P=Phased Ret/Former Enlisted FE
W=Phased Retiree/Former CS
X=CSRS Phased Retiree Officer
Y=Phased Ret/Former Enlisted CS

Default Value: 9

44 GVT_FEGLI Character(2) VARCHAR2(2) NOT NULL FEGLI Code

Default Value: C0

45 GVT_FEGLI_LIVING Character(1) VARCHAR2(1) NOT NULL FEGLI Living Benefits

Y/N Table Edit

Default Value: N

46 GVT_LIVING_AMT Number(8,0) INTEGER NOT NULL Living Benefit Coverage Amount
47 GVT_ANNUITY_OFFSET Number(8,0) INTEGER NOT NULL Annuity Offset Amount
48 GVT_CSRS_FROZN_SVC Character(4) VARCHAR2(4) NOT NULL CSRS Frozen Service
49 GVT_PREV_RET_COVRG Character(1) VARCHAR2(1) NOT NULL Previous Retirement Coverage
N=Never Covered
P=Previously Covered

Default Value: N

50 GVT_FERS_COVERAGE Character(1) VARCHAR2(1) NOT NULL FERS Coverage
A=Automatically Covered By FERS
E=Elected Coverage Under FERS
N=Not Covered By FERS

Default Value: A

51 GVT_TYPE_OF_APPT Character(2) VARCHAR2(2) NOT NULL Type of Appointment
10=Career (Competitive Svc Perm)
15=Career-Conditional (Comp Perm)
20=Nonpermanent (Comp NonPerm)
30=Schedule A (Except Svc Perm)
32=Schedule B (Except Svc Perm)
34=Schedule C (Except Svc Perm)
36=Executive (Except Svc Perm)
38=Other (Except Svc Perm)
40=Schedule A (Except NonPerm)
42=Schedule B (Except NonPerm)
44=Schedule C (Except NonPerm)
46=Executive (Except NonPerm)
48=Other (Except NonPerm)
50=Career (Senior Exec Perm)
55=Noncareer (Senior Exec Perm)
60=Limited Term (Senior Exec NPrm
65=Limited Emergency (SES NPerm)

Default Value: 10

52 GVT_POI Character(4) VARCHAR2(4) NOT NULL Personnel Office ID
53 GVT_POSN_OCCUPIED Character(1) VARCHAR2(1) NOT NULL Position Occupied
1=Competitive
2=Excepted
3=SES General
4=SES Career Reserved
54 GVT_CONT_EMPLID Character(11) VARCHAR2(11) NOT NULL Contact Emplid
55 GVT_ROUTE_NEXT Character(11) VARCHAR2(11) NOT NULL Route to Next
56 GVT_CHANGE_FLAG Character(1) VARCHAR2(1) NOT NULL Change Flag

Y/N Table Edit

Default Value: N

57 GVT_TSP_UPD_IND Character(1) VARCHAR2(1) NOT NULL TSP Status
N=Not Ready
P=Processed
R=Ready

Default Value: N

58 GVT_PI_UPD_IND Character(1) VARCHAR2(1) NOT NULL PI upd ind
A=Applied at NFC
I=Auto Action Inserted
N=Not Ready to Process
P=In Process
R=Ready To Process
S=SINQ Error
Z=Other

Default Value: N

59 GVT_SF52_NBR Character(10) VARCHAR2(10) NOT NULL SF-52 Request Number
60 GVT_S113G_CEILING Character(1) VARCHAR2(1) NOT NULL SF-113G Ceiling

Y/N Table Edit

Default Value: Y

61 GVT_LEO_POSITION Character(1) VARCHAR2(1) NOT NULL LEO/Fire Position
5=5USC 5305 LEO
C=D.C. Police Forces
F=Fire Fighter
N=Not Applicable
P=Primary FEPCA
S=Secondary FEPCA
62 GVT_ANNUIT_COM_DT Date(10) DATE Annuity Commencement Date
63 GVT_BASIC_LIFE_RED Character(2) VARCHAR2(2) NOT NULL Federal Field
0=No Reduction
50=50% Reduction
75=75% Reduction
N=None
64 GVT_DED_PRORT_DT Date(10) DATE 4 Day Date
65 GVT_FEGLI_BASC_PCT Number(8,6) DECIMAL(7,6) NOT NULL FEGLI Basic Percent
66 GVT_FEGLI_OPT_PCT Number(8,6) DECIMAL(7,6) NOT NULL FEGLI Optional Percent
67 GVT_FEHB_PCT Number(8,6) DECIMAL(7,6) NOT NULL FEHB %
68 GVT_RETRO_FLAG Character(1) VARCHAR2(1) NOT NULL Retro Pay Flag

Default Value: N

69 GVT_RETRO_DED_FLAG Character(1) VARCHAR2(1) NOT NULL Retro Ded Flag

Default Value: N

70 GVT_RETRO_JOB_FLAG Character(1) VARCHAR2(1) NOT NULL Retro Job Flag

Default Value: N

71 GVT_RETRO_BSE_FLAG Character(1) VARCHAR2(1) NOT NULL Retro Base Flag

Default Value: N

72 GVT_OTH_PAY_CHG Character(1) VARCHAR2(1) NOT NULL Other Pay Change Flag

Default Value: N

73 GVT_DETL_POSN_NBR Character(8) VARCHAR2(8) NOT NULL Govt Detail Position Number
74 ANNL_BEN_BASE_OVRD Character(1) VARCHAR2(1) NOT NULL Annual Benefit Base Rate Override

Y/N Table Edit

Default Value: N

75 BENEFIT_PROGRAM Character(3) VARCHAR2(3) NOT NULL Defines a collection of benefit plans and their associated rate and calculation rules.
76 UPDATE_PAYROLL Character(1) VARCHAR2(1) NOT NULL Update Payroll Flags
77 GVT_PAY_PLAN Character(2) VARCHAR2(2) NOT NULL Pay Plan
78 GVT_PAY_FLAG Character(1) VARCHAR2(1) NOT NULL Pay Flag
79 GVT_NID_CHANGE Character(1) VARCHAR2(1) NOT NULL GVT_NID_CHANGE

Default Value: Y

80 GVT_SCD_RETIRE Date(10) DATE Service Comp Date - Retire
81 GVT_SCD_TSP Date(10) DATE Service Comp Date - TSP
82 GVT_SCD_LEO Date(10) DATE Service Comp Date - LEO
83 GVT_SCD_SEVPAY Date(10) DATE Service Comp Date - Sev Pay
84 GVT_SEVPAY_PRV_WKS Number(2,0) SMALLINT NOT NULL Severance Pay Previous Weeks
85 GVT_MAND_RET_DT Date(10) DATE Mandatory Retirement Date
86 GVT_WGI_STATUS Character(1) VARCHAR2(1) NOT NULL Current WGI Status
A=Approved
C=WGI Created
D=Denied
M=Manual WGI
N=WGI Not Applicable
P=Postponed
W=Waiting WGI Processing

Default Value: W

87 GVT_INTRM_DAYS_WGI Number(3,0) SMALLINT NOT NULL Intermittent Days Worked
88 GVT_NONPAY_NOA Character(3) VARCHAR2(3) NOT NULL NonPay Nature of Action - Last
89 GVT_NONPAY_HRS_WGI Number(7,2) DECIMAL(6,2) NOT NULL Non-Pay Hours WGI
90 GVT_NONPAY_HRS_SCD Number(7,2) DECIMAL(6,2) NOT NULL Non-Pay Hours for SCD
91 GVT_NONPAY_HRS_TNR Number(7,2) DECIMAL(6,2) NOT NULL Career Tenure Hours
92 GVT_NONPAY_HRS_PRB Number(7,2) DECIMAL(6,2) NOT NULL Non-Pay Hours for Probation
93 GVT_TEMP_PRO_EXPIR Date(10) DATE Temp Promotion Expires
94 GVT_TEMP_PSN_EXPIR Date(10) DATE Temporary Posn Change Expires
95 GVT_DETAIL_EXPIRES Date(10) DATE Date Detail Expires
96 GVT_SABBATIC_EXPIR Date(10) DATE Date Sabbatical Expires
97 GVT_RTND_GRADE_BEG Date(10) DATE Retained Grade Begins
98 GVT_RTND_GRADE_EXP Date(10) DATE Retained Grade Expires
99 GVT_CURR_APT_AUTH1 Character(3) VARCHAR2(3) NOT NULL Current Appointment Auth Nbr 1
100 GVT_CURR_APT_AUTH2 Character(3) VARCHAR2(3) NOT NULL Current Appointment Auth Nbr 2
101 GVT_APPT_EXPIR_DT Date(10) DATE Appointment Expiration Date
102 GVT_CNV_BEGIN_DATE Date(10) DATE Conv Begin Date
103 GVT_CAREER_CNV_DUE Date(10) DATE Conversion To Career Due
104 GVT_CAREER_COND_DT Date(10) DATE Career Cond Conversion Date
105 GVT_APPT_LIMIT_HRS Number(4,0) SMALLINT NOT NULL Appointment Limit in Hours
106 GVT_APPT_LIMIT_DYS Number(3,0) SMALLINT NOT NULL Appointment Limit in Days
107 GVT_APPT_LIMIT_AMT Number(6,0) INTEGER NOT NULL Appointment Limit Amount
108 GVT_SUPV_PROB_DT Date(10) DATE Supv/Manager Probation Date
109 GVT_SES_PROB_DT Date(10) DATE SES Probation Date
110 GVT_SEC_CLR_STATUS Character(1) VARCHAR2(1) NOT NULL Security Clearance Status
A=Approved
B=Pending - Investigative Agency
C=Pending - Employee
D=Pending - Agency
N=Not Applicable
S=Suspended

Default Value: N

111 GVT_CLRNCE_STAT_DT Date(10) DATE Security Clearance Status Date

Default Value: %date

112 GVT_ERN_PGM_PERM Character(2) VARCHAR2(2) NOT NULL Permanent Pay Plan - RIF
113 GVT_OCC_SERS_PERM Character(4) VARCHAR2(4) NOT NULL Permanent Occ Series - RIF
114 GVT_GRADE_PERM Character(3) VARCHAR2(3) NOT NULL Permanent Grade - RIF
115 GVT_COMP_AREA_PERM Character(2) VARCHAR2(2) NOT NULL Comp/Area Level
116 GVT_COMP_LVL_PERM Character(3) VARCHAR2(3) NOT NULL Permanent Comp Level - RIF
117 GVT_SPEP Character(2) VARCHAR2(2) NOT NULL Special Employment Program
00=Not Applicable
59=Veteran's Readjustment Program
69=Presidential Mgt Intern
80=SES Candidate Development
99=Other

Default Value: 00

118 GVT_WGI_DUE_DATE Date(10) DATE Within-Grade Increase Due Date
119 GVT_DT_LEI Date(10) DATE Date Last Equivalent Increase
120 GVT_FIN_DISCLOSURE Character(1) VARCHAR2(1) NOT NULL Financial Disclosure Required

Y/N Table Edit

121 GVT_FIN_DISCL_DATE Date(10) DATE Financial Disclosure Due Date
122 GVT_TENURE Character(1) VARCHAR2(1) NOT NULL Highest Career Tenure
0=None
1=Permanent
2=Conditional
3=Indefinite
123 GVT_DETL_BARG_UNIT Character(4) VARCHAR2(4) NOT NULL Govt Detail Bargaining Unit
124 GVT_DETL_UNION_CD Character(3) VARCHAR2(3) NOT NULL Govt Detail Union Code
125 GVT_WELFARE_WK_CD Character(2) VARCHAR2(2) NOT NULL Welfare to Work
00=Not Applicable
50=Welfare to Work Program Hire
50=Welfare to Work Program Hire
60=Hire not Welfare to Work Prog
60=Hire not Welfare to Work Prog

Default Value: 00