GP_DIAG_JOB_VW (SQL View)	Index Back
GP-Diagnostic.. JOB Derivated Row to select fields that could be send from customer to PeopleSoft

GP_DIAG_JOB_VW

(SQL View)

GP-Diagnostic.. JOB

Derivated Row to select fields that could be send from customer to PeopleSoft

SELECT EMPLID ,EMPL_RCD ,EFFDT ,EFFSEQ ,PER_ORG ,HR_STATUS ,EMPL_STATUS ,ACTION ,ACTION_REASON ,COMPANY ,CONTRACT_NUM ,DEPTID ,ESTABID ,PAY_SYSTEM_FLG ,GP_PAYGROUP ,GP_DFLT_ELIG_GRP ,GP_ELIG_GRP FROM PS_JOB

# 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 Rcd Nbr

3 EFFDT Date(10) DATE Effective Date

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

5 PER_ORG Character(3) VARCHAR2(3) NOT NULL Defines the Organizational Relationship(s) that a Person has to the Organization. These are Employee, Contingent Worker, and Persons of Interest.
CWR=Contingent Worker
EMP=Employee
POI=Person of Interest

6 HR_STATUS Character(1) VARCHAR2(1) NOT NULL HR Status
A=Active
I=Inactive

7 EMPL_STATUS Character(1) VARCHAR2(1) NOT NULL Payroll Status
A=Active
D=Deceased
L=Leave of Absence
P=Leave With Pay
Q=Retired With Pay
R=Retired
S=Suspended
T=Terminated
U=Terminated With Pay
V=Terminated Pension Pay Out
W=Short Work Break
X=Retired-Pension Administration

8 ACTION Character(3) VARCHAR2(3) NOT NULL Action

9 ACTION_REASON Character(3) VARCHAR2(3) NOT NULL Reason Code

10 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

11 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract Number

12 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

13 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID

14 PAY_SYSTEM_FLG Character(2) VARCHAR2(2) NOT NULL Payroll System
GP=Global Payroll
NA=Payroll for North America
OT=Other
PI=Payroll Interface

15 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group

16 GP_DFLT_ELIG_GRP Character(1) VARCHAR2(1) NOT NULL Y/N assign default value from Pay Group (as opposed to assigning value at the payee / job level)

17 GP_ELIG_GRP Character(10) VARCHAR2(10) NOT NULL Eligibility Group

#	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 Rcd Nbr
3	EFFDT	Date(10)	DATE	Effective Date
4	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
5	PER_ORG	Character(3)	VARCHAR2(3) NOT NULL	Defines the Organizational Relationship(s) that a Person has to the Organization. These are Employee, Contingent Worker, and Persons of Interest. CWR=Contingent Worker EMP=Employee POI=Person of Interest
6	HR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	HR Status A=Active I=Inactive
7	EMPL_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Payroll Status A=Active D=Deceased L=Leave of Absence P=Leave With Pay Q=Retired With Pay R=Retired S=Suspended T=Terminated U=Terminated With Pay V=Terminated Pension Pay Out W=Short Work Break X=Retired-Pension Administration
8	ACTION	Character(3)	VARCHAR2(3) NOT NULL	Action
9	ACTION_REASON	Character(3)	VARCHAR2(3) NOT NULL	Reason Code
10	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
11	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract Number
12	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
13	ESTABID	Character(12)	VARCHAR2(12) NOT NULL	Establishment ID
14	PAY_SYSTEM_FLG	Character(2)	VARCHAR2(2) NOT NULL	Payroll System GP=Global Payroll NA=Payroll for North America OT=Other PI=Payroll Interface
15	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
16	GP_DFLT_ELIG_GRP	Character(1)	VARCHAR2(1) NOT NULL	Y/N assign default value from Pay Group (as opposed to assigning value at the payee / job level)
17	GP_ELIG_GRP	Character(10)	VARCHAR2(10) NOT NULL	Eligibility Group