EX_AA_EE_ORG_VW

(SQL View)
 Index Back

Employee Default Profile Vw

Employee Default Profile Vw

SELECT A.EMPLID , B.EMPL_RCD , A.DFLT_ADDR_FLG , B.BUSINESS_UNIT_GL , D.BASE_CURRENCY , D.EXP_RPT_LIMIT , D.TIME_RPT_LIMIT , E.TERMINATION_DT , B.ADVANCE_LVL , B.ADV_MAX_AMT , B.CURRENCY_CD , C.JOBCODE , CASE WHEN B.DEPTID <> ' ' THEN B.DEPTID ELSE C.DEPTID END ,%subrec(CF16_AN_SBR,B) , ' ' , B.PROJECT_ID , ' ' , ' ' , ' ' , ' ' , ' ' , C.EMPL_STATUS , C.HOLIDAY_SCHEDULE , B.EE_VAL_FLG , B.EE_VAL_REASON_CD , B.LOC_AMT_EXCL_FLG , B.PYMNT_METHOD , B.PYMNT_HOLD , B.GST_APPLICABLE , B.ORGANIZATION_GSTIN , B.ORGANIZATION_NAME FROM PS_EX_EE_ORG_DTA A , PS_EX_EE_ORG_DTL B , PS_JOB C , PS_BUS_UNIT_TBL_EX D , PS_EMPLOYMENT E WHERE A.EMPLID = B.EMPLID AND B.DFLT_EE_PROF_FLG = 'Y' AND C.EMPLID = B.EMPLID AND C.EMPL_RCD = B.EMPL_RCD AND E.EMPLID = C.EMPLID AND E.EMPL_RCD = C.EMPL_RCD AND C.EFFDT = ( SELECT MAX(C1.EFFDT) FROM PS_JOB C1 WHERE C1.EMPLID = C.EMPLID AND C1.EMPL_RCD = C.EMPL_RCD AND C1.EFFDT <= %CurrentDateIn) AND C.EFFSEQ = ( SELECT MAX(C2.EFFSEQ) FROM PS_JOB C2 WHERE C2.EMPLID = C.EMPLID AND C2.EMPL_RCD = C.EMPL_RCD AND C2.EFFDT = C.EFFDT) AND D.BUSINESS_UNIT_GL = B.BUSINESS_UNIT_GL

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

Prompt Table: PERSONAL_DATA

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
3 DFLT_ADDR_FLG Character(1) VARCHAR2(1) NOT NULL Default Address Flag
H=Home Address
M=Mailing Address
4 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

Prompt Table: EX_BU_PROMPT_VW

5 BASE_CURRENCY Character(3) VARCHAR2(3) NOT NULL "Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
6 EXP_RPT_LIMIT Number(3,0) SMALLINT NOT NULL Expense Submission Grace Days
7 TIME_RPT_LIMIT Number(3,0) SMALLINT NOT NULL Time Submission Grace Days
8 TERMINATION_DT Date(10) DATE Termination Date
9 ADVANCE_LVL Character(1) VARCHAR2(1) NOT NULL Cash Advance Level
B=Business Unit
N=None
S=Specific Amount
10 ADV_MAX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Cash Advance Maximum
11 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
12 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
13 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

Prompt Table: DEPTID_BUGL_VW

14 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField

Prompt Table: OPERUNT_BUGL_VW

15 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField

Prompt Table: PRODUCT_BUGL_VW

16 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code

Prompt Table: FUND_BUGL_VW

17 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field

Prompt Table: CLASSCF_BUGL_VW

18 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField

Prompt Table: PROGRAM_BUGL_VW

19 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference

Prompt Table: BUD_REF_BUGL_VW

20 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate

Prompt Table: AFFILIATE_VW

21 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1

Prompt Table: %EDIT_INTRA01

22 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate

Prompt Table: %EDIT_INTRA02

23 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1

Prompt Table: CF1_BUGL_VW

24 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2

Prompt Table: CF2_BUGL_VW

25 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3

Prompt Table: CF3_BUGL_VW

26 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit

Prompt Table: %EDIT_BU_PC

27 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

Prompt Table: %EDIT_PROJECT

28 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID

Prompt Table: %EDIT_ACTIVITY

29 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type

Prompt Table: PROJ_RESTYPE_FS
Set Control Field: BUSINESS_UNIT_PC

30 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category

Prompt Table: %EDIT_RES_CAT
Set Control Field: BUSINESS_UNIT_PC

31 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory

Prompt Table: %EDIT_RES_SUB
Set Control Field: BUSINESS_UNIT_PC

32 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type

Prompt Table: %EDIT_ANALYSIS
Set Control Field: BUSINESS_UNIT_PC

33 EMPL_STATUS Character(1) VARCHAR2(1) NOT NULL Employee Status
A=Active
D=Deceased
I=Inactive
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
34 HOLIDAY_SCHEDULE Character(6) VARCHAR2(6) NOT NULL Holiday Schedule
35 EE_VAL_FLG Character(1) VARCHAR2(1) NOT NULL Valid for Expenses
N=No
Y=Yes
36 EE_VAL_REASON_CD Character(1) VARCHAR2(1) NOT NULL Reason for Status
A=No Bank Account Selected
B=Invalid Business Unit
D=Invalid Department
P=Passed All Validation Edits
37 LOC_AMT_EXCL_FLG Character(1) VARCHAR2(1) NOT NULL Ignore Authorized Amounts
38 PYMNT_METHOD Character(3) VARCHAR2(3) NOT NULL Payment Method
ACH=Automated Clearing House
BEF=Draft - Customer EFT
BOO=Draft - Customer Initiated
CHK=System Check
D=Deposit
DD=Direct Debit
DFT=Draft - Supplier Initiated
DRA=Draft
EFT=Electronic Funds Transfer
GE=Giro - EFT
GM=Giro - Manual
LC=Letter of Credit
MAN=Manual Check
TRW=Treasury Wire
WIR=Wire Transfer
39 PYMNT_HOLD Character(1) VARCHAR2(1) NOT NULL Hold Payment
N=No
Y=Yes
40 GST_APPLICABLE Character(1) VARCHAR2(1) NOT NULL GST Applicable
N=No
Y=Yes
41 ORGANIZATION_GSTIN Character(30) VARCHAR2(30) NOT NULL Organization GSTIN Number
42 ORGANIZATION_NAME Character(50) VARCHAR2(50) NOT NULL Organization Name