HGA_ABS_SI_VW (SQL View)	Index Back
Absence Event details Absence Event details view used in the query for search and Insights Visualization

HGA_ABS_SI_VW

(SQL View)

Absence Event details

Absence Event details view used in the query for search and Insights Visualization

SELECT A.EMPLID ,A.EMPL_RCD ,A.BGN_DT ,A.PIN_TAKE_NUM ,A.END_DT ,A.ORIG_BEGIN_DT ,A.ABS_ENTRY_SRC ,A.PRC_EVT_ACTN_OPTN ,A.VOIDED_IND ,A.ABSENCE_REASON ,A.BEGIN_DAY_HRS ,A.BEGIN_DAY_HALF_IND ,A.END_DAY_HRS ,A.END_DAY_HALF_IND ,A.ALL_DAYS_IND ,A.MANAGER_APPR_IND ,A.OVRD_ENT_VAL ,A.OVRD_ADJ_VAL ,A.CAL_RUN_ID ,A.PYE_RUN_NUM ,A.LAST_UPDT_DT ,A.PROCESS_DT ,A.ABS_EVT_FCST_VAL ,A.FCST_DTTM ,A.DURATION_ABS ,A.DURATION_HRS ,A.DURATION_DYS ,A.ACTION_DT_SS ,A.WF_STATUS ,A.TRANSACTION_NBR ,A.TRANSACTION_NBR_EA ,A.FIRST_PROC_DT ,A.COMMENT1 ,A.USED_BY ,A.COUNTRY ,A.ABS_TYPE_OPTN ,A.GP_ABS_EVT_STAT ,A.FISCAL_YEAR ,A.CALENDAR_YEAR ,A.ABS_PARTIAL_DAYS ,A.ABS_CATEGORY ,A.GP_PAYGROUP ,A.CAL_ID ,A.PRD_TYPE ,%Sql(HGA_GET_QUARTER, A.BGN_DT, %Sql(HGA_EVT_PRD_BGN_YR, A.BGN_DT, A.TEXT1), A.START_MTH_FSCL, A.START_DAY_FSCL) ,%Sql(HGA_GET_QUARTER, A.BGN_DT, %Sql(HGA_EVT_PRD_BGN_YR, A.BGN_DT, A.TEXT2), A.START_MTH_CAL, A.START_DAY_CAL) ,A.UNIT_TYPE ,A.LASTUPDDTTM ,A.TRANSACTION_NBR_AT ,A.EOAWSTEP_STATUS ,A.OPRID ,A.EOAWDTTM_MODIFIED ,A.DTTM_MODIFIED ,A.DTTM_CREATED ,A.EOAWUSTEP_STATUS ,A.JOBCODE ,A.EMPL_STATUS ,A.ACTION_REASON ,A.FULL_PART_TIME ,A.PAYGROUP ,A.LASTUPDDTTM_J ,A.HOURLY_RT ,A.DAILY_RT ,A.CURRENCY_CD ,A.DEPTID ,A.HR_STATUS ,A.REPORTS_TO ,A.COMPANY ,A.SETID_JOBCODE ,A.SETID_DEPT ,A.SETID_LOCATION ,A.BUSINESS_UNIT ,A.LOCATION ,A.POSITION_NBR ,A.REG_REGION ,A.ESTABID ,A.EFFDT ,A.EMPLID_CURR_APPR ,A.COUNTRY2 FROM PS_HGA_ABS_DTL_TMP A

# 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 Record

3 BGN_DT Date(10) DATE NOT NULL Begin Date

4 PIN_TAKE_NUM Number(8,0) INTEGER NOT NULL Absence Take
Prompt Table: GP_PIN_ABSTK_VW

5 END_DT Date(10) DATE end date

6 ORIG_BEGIN_DT Date(10) DATE original begin date
Default Value: GP_ABS_EVENT.BGN_DT

7 ABS_ENTRY_SRC Character(1) VARCHAR2(1) NOT NULL Absence Entry Source
1=Administrator Absence Event
2=Time & Labor
3=Third Party
4=Employee Absence Request
5=Manager Absence Request
6=Employee Timesheet
7=Manager Timesheet
A=Employee Extended Absence
B=Manager Extended Absence
C=Administrator Extended Absence
D=Employee Desktop Integration
Default Value: 1

8 PRC_EVT_ACTN_OPTN Character(1) VARCHAR2(1) NOT NULL Process Action Event Indicator
N=Normal
V=Void
Default Value: N

9 VOIDED_IND Character(1) VARCHAR2(1) NOT NULL Voided Indicator
Y/N Table Edit
Default Value: N

10 ABSENCE_REASON Character(3) VARCHAR2(3) NOT NULL absence reason
Prompt Table: %GP_EDIT_FLD1

11 BEGIN_DAY_HRS Signed Number(6,2) DECIMAL(4,2) NOT NULL Partial Hours

12 BEGIN_DAY_HALF_IND Character(1) VARCHAR2(1) NOT NULL indicates whether first day of an absence event began counts as half a day
Y/N Table Edit
Default Value: N

13 END_DAY_HRS Signed Number(6,2) DECIMAL(4,2) NOT NULL partial hours end

14 END_DAY_HALF_IND Character(1) VARCHAR2(1) NOT NULL half day end indicator
Y/N Table Edit
Default Value: N

15 ALL_DAYS_IND Character(1) VARCHAR2(1) NOT NULL All Days Indicator
N=Apply To Begin Day Only
Y=Apply To All Days
Default Value: N

16 MANAGER_APPR_IND Character(1) VARCHAR2(1) NOT NULL Manager Approved
Y/N Table Edit
Default Value: N

17 OVRD_ENT_VAL Signed Number(12,6) DECIMAL(10,6) NOT NULL Override Entitlement Amoung

18 OVRD_ADJ_VAL Signed Number(8,2) DECIMAL(6,2) NOT NULL Override Adjustment Amoung

19 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id

20 PYE_RUN_NUM Number(8,0) INTEGER NOT NULL Number to link to Payee Run Table

21 LAST_UPDT_DT Date(10) DATE Date of last Update

22 PROCESS_DT Date(10) DATE Process Date

23 ABS_EVT_FCST_VAL Character(30) VARCHAR2(30) NOT NULL This field is used on the GP_ABS_EVENT record to record the value of the resolved related forecast element.

24 FCST_DTTM DateTime(26) TIMESTAMP This field is used on the GP_ABS_EVENT to record the last time forecasting was run for this event.

25 DURATION_ABS Number(7,2) DECIMAL(6,2) NOT NULL Duration field containing 2 decimals to handle absence requirements

26 DURATION_HRS Number(7,2) DECIMAL(6,2) NOT NULL Duration Hrs

27 DURATION_DYS Number(7,2) DECIMAL(6,2) NOT NULL Duration field containing 2 decimals to handle absence requirements

28 ACTION_DT_SS Date(10) DATE Date Submitted

29 WF_STATUS Character(1) VARCHAR2(1) NOT NULL Workflow Status
A=Approved
C=Cancelled
D=Denied
E=Error. Contact Administrator.
F=Awaiting final approval
I=In Approval Process
M=Administrator is Processing
N=Not Available
P=Rework
S=Submitted
V=Data Saved

30 TRANSACTION_NBR Number(15,0) DECIMAL(15) NOT NULL 08/02/99 NAS: Changed the size of this field from 10 to 15. Based on Jim Hillman's decision to make the field at a standard size.

31 TRANSACTION_NBR_EA Number(15,0) DECIMAL(15) NOT NULL The Extendned Absence transaction number
Default Value: 0

32 FIRST_PROC_DT Date(10) DATE GP Core/Abs Mgt field to track when an absence was first processed. This date will not change regardless of how many retro runs are run against the absence subsequent to the initial calculation.

33 COMMENT1 Character(254) VARCHAR2(254) NOT NULL Comments

34 USED_BY Character(1) VARCHAR2(1) NOT NULL USED_BY
A=All Countries
C=Specific Country

35 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

36 ABS_TYPE_OPTN Character(3) VARCHAR2(3) NOT NULL Absence Type

37 GP_ABS_EVT_STAT Character(1) VARCHAR2(1) NOT NULL Absence event status
F=Finalized
N=Not Processed
P=Processed

38 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year

39 CALENDAR_YEAR Number(4,0) SMALLINT NOT NULL Calendar Year

40 ABS_PARTIAL_DAYS Character(3) VARCHAR2(3) NOT NULL Partial Days Indicator
ADH=All Day Half
ALL=All Day
BD=Begin Day Hours
BDH=Begin Day Half
BE=Begin and Day Hours
BEH=Begin and End days Half
ED=End Day Hours
EDH=End Day Half

41 ABS_CATEGORY Character(1) VARCHAR2(1) NOT NULL Absence Category
A=Approved
O=Other
P=Planned

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

43 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id

44 PRD_TYPE Character(1) VARCHAR2(1) NOT NULL Period Type
C=Current
R=Retro

45 FISCAL_QUARTER Character(2) VARCHAR2(2) NOT NULL Fiscal Quarter

46 CALENDAR_QUARTER Character(2) VARCHAR2(2) NOT NULL Calendar Quarter

47 UNIT_TYPE Character(1) VARCHAR2(1) NOT NULL Unit Type in which the absence balances are displayed
D=Days
H=Hours

48 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

49 TRANSACTION_NBR_AT Number(15,0) DECIMAL(15) NOT NULL This field is created to support the Attachments on Request Absence Fluid page

50 EOAWSTEP_STATUS Character(1) VARCHAR2(1) NOT NULL Step Instance Status
A=Approved
B=Pushed back
C=Auto Approved
D=Denied
E=Administrator denied
F=Deleted
G=Bypassed
H=On Hold
I=No Action Taken
K=Skipped
L=Terminated
M=Administrator approved
N=Not Active
P=Pending
R=No longer in role
T=Terminated
U=Auto approved
X=Deleted
Z=Pending Denial

51 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

52 EOAWDTTM_MODIFIED DateTime(26) TIMESTAMP Datetime modified

53 DTTM_MODIFIED DateTime(26) TIMESTAMP Datetime modified

54 DTTM_CREATED DateTime(26) TIMESTAMP Datetime Created

55 EOAWUSTEP_STATUS Character(1) VARCHAR2(1) NOT NULL Approver Status
A=Approved
B=Pushed back
C=Auto Approved
D=Denied
E=Administrator denied
F=Deleted
G=Bypassed
H=Hold
K=Skipped
L=Terminated
M=Administrator approved
N=Not Active
P=Pending
S=Skipped
T=Terminated
U=Auto approved
W=Canceled
X=Deleted
Y=Bypassed

56 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

57 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

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

59 FULL_PART_TIME Character(1) VARCHAR2(1) NOT NULL Full/Part Time
D=On Demand
F=Full-Time
P=Part-Time

60 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group

61 LASTUPDDTTM_J DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

62 HOURLY_RT Number(19,6) DECIMAL(18,6) NOT NULL Hourly Rate

63 DAILY_RT Number(19,3) DECIMAL(18,3) NOT NULL Daily Rate

64 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

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

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

67 REPORTS_TO Character(8) VARCHAR2(8) NOT NULL Reports To Position Number

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

69 SETID_JOBCODE Character(5) VARCHAR2(5) NOT NULL Job Code Set ID

70 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department Set ID

71 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location Set ID

72 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

73 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

74 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number

75 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region

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

77 EFFDT Date(10) DATE Effective Date
Default Value: %date

78 EMPLID_CURR_APPR Character(11) VARCHAR2(11) NOT NULL Stores the Employee ID of the Current Approver in Federal Self-Service Transactions.

79 COUNTRY2 Character(3) VARCHAR2(3) NOT NULL Country

#	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 Record
3	BGN_DT	Date(10)	DATE NOT NULL	Begin Date
4	PIN_TAKE_NUM	Number(8,0)	INTEGER NOT NULL	Absence Take Prompt Table: GP_PIN_ABSTK_VW
5	END_DT	Date(10)	DATE	end date
6	ORIG_BEGIN_DT	Date(10)	DATE	original begin date Default Value: GP_ABS_EVENT.BGN_DT
7	ABS_ENTRY_SRC	Character(1)	VARCHAR2(1) NOT NULL	Absence Entry Source 1=Administrator Absence Event 2=Time & Labor 3=Third Party 4=Employee Absence Request 5=Manager Absence Request 6=Employee Timesheet 7=Manager Timesheet A=Employee Extended Absence B=Manager Extended Absence C=Administrator Extended Absence D=Employee Desktop Integration Default Value: 1
8	PRC_EVT_ACTN_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Process Action Event Indicator N=Normal V=Void Default Value: N
9	VOIDED_IND	Character(1)	VARCHAR2(1) NOT NULL	Voided Indicator Y/N Table Edit Default Value: N
10	ABSENCE_REASON	Character(3)	VARCHAR2(3) NOT NULL	absence reason Prompt Table: %GP_EDIT_FLD1
11	BEGIN_DAY_HRS	Signed Number(6,2)	DECIMAL(4,2) NOT NULL	Partial Hours
12	BEGIN_DAY_HALF_IND	Character(1)	VARCHAR2(1) NOT NULL	indicates whether first day of an absence event began counts as half a day Y/N Table Edit Default Value: N
13	END_DAY_HRS	Signed Number(6,2)	DECIMAL(4,2) NOT NULL	partial hours end
14	END_DAY_HALF_IND	Character(1)	VARCHAR2(1) NOT NULL	half day end indicator Y/N Table Edit Default Value: N
15	ALL_DAYS_IND	Character(1)	VARCHAR2(1) NOT NULL	All Days Indicator N=Apply To Begin Day Only Y=Apply To All Days Default Value: N
16	MANAGER_APPR_IND	Character(1)	VARCHAR2(1) NOT NULL	Manager Approved Y/N Table Edit Default Value: N
17	OVRD_ENT_VAL	Signed Number(12,6)	DECIMAL(10,6) NOT NULL	Override Entitlement Amoung
18	OVRD_ADJ_VAL	Signed Number(8,2)	DECIMAL(6,2) NOT NULL	Override Adjustment Amoung
19	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
20	PYE_RUN_NUM	Number(8,0)	INTEGER NOT NULL	Number to link to Payee Run Table
21	LAST_UPDT_DT	Date(10)	DATE	Date of last Update
22	PROCESS_DT	Date(10)	DATE	Process Date
23	ABS_EVT_FCST_VAL	Character(30)	VARCHAR2(30) NOT NULL	This field is used on the GP_ABS_EVENT record to record the value of the resolved related forecast element.
24	FCST_DTTM	DateTime(26)	TIMESTAMP	This field is used on the GP_ABS_EVENT to record the last time forecasting was run for this event.
25	DURATION_ABS	Number(7,2)	DECIMAL(6,2) NOT NULL	Duration field containing 2 decimals to handle absence requirements
26	DURATION_HRS	Number(7,2)	DECIMAL(6,2) NOT NULL	Duration Hrs
27	DURATION_DYS	Number(7,2)	DECIMAL(6,2) NOT NULL	Duration field containing 2 decimals to handle absence requirements
28	ACTION_DT_SS	Date(10)	DATE	Date Submitted
29	WF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Workflow Status A=Approved C=Cancelled D=Denied E=Error. Contact Administrator. F=Awaiting final approval I=In Approval Process M=Administrator is Processing N=Not Available P=Rework S=Submitted V=Data Saved
30	TRANSACTION_NBR	Number(15,0)	DECIMAL(15) NOT NULL	08/02/99 NAS: Changed the size of this field from 10 to 15. Based on Jim Hillman's decision to make the field at a standard size.
31	TRANSACTION_NBR_EA	Number(15,0)	DECIMAL(15) NOT NULL	The Extendned Absence transaction number Default Value: 0
32	FIRST_PROC_DT	Date(10)	DATE	GP Core/Abs Mgt field to track when an absence was first processed. This date will not change regardless of how many retro runs are run against the absence subsequent to the initial calculation.
33	COMMENT1	Character(254)	VARCHAR2(254) NOT NULL	Comments
34	USED_BY	Character(1)	VARCHAR2(1) NOT NULL	USED_BY A=All Countries C=Specific Country
35	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
36	ABS_TYPE_OPTN	Character(3)	VARCHAR2(3) NOT NULL	Absence Type
37	GP_ABS_EVT_STAT	Character(1)	VARCHAR2(1) NOT NULL	Absence event status F=Finalized N=Not Processed P=Processed
38	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
39	CALENDAR_YEAR	Number(4,0)	SMALLINT NOT NULL	Calendar Year
40	ABS_PARTIAL_DAYS	Character(3)	VARCHAR2(3) NOT NULL	Partial Days Indicator ADH=All Day Half ALL=All Day BD=Begin Day Hours BDH=Begin Day Half BE=Begin and Day Hours BEH=Begin and End days Half ED=End Day Hours EDH=End Day Half
41	ABS_CATEGORY	Character(1)	VARCHAR2(1) NOT NULL	Absence Category A=Approved O=Other P=Planned
42	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
43	CAL_ID	Character(18)	VARCHAR2(18) NOT NULL	calendar id
44	PRD_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Period Type C=Current R=Retro
45	FISCAL_QUARTER	Character(2)	VARCHAR2(2) NOT NULL	Fiscal Quarter
46	CALENDAR_QUARTER	Character(2)	VARCHAR2(2) NOT NULL	Calendar Quarter
47	UNIT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Unit Type in which the absence balances are displayed D=Days H=Hours
48	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
49	TRANSACTION_NBR_AT	Number(15,0)	DECIMAL(15) NOT NULL	This field is created to support the Attachments on Request Absence Fluid page
50	EOAWSTEP_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Step Instance Status A=Approved B=Pushed back C=Auto Approved D=Denied E=Administrator denied F=Deleted G=Bypassed H=On Hold I=No Action Taken K=Skipped L=Terminated M=Administrator approved N=Not Active P=Pending R=No longer in role T=Terminated U=Auto approved X=Deleted Z=Pending Denial
51	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
52	EOAWDTTM_MODIFIED	DateTime(26)	TIMESTAMP	Datetime modified
53	DTTM_MODIFIED	DateTime(26)	TIMESTAMP	Datetime modified
54	DTTM_CREATED	DateTime(26)	TIMESTAMP	Datetime Created
55	EOAWUSTEP_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Approver Status A=Approved B=Pushed back C=Auto Approved D=Denied E=Administrator denied F=Deleted G=Bypassed H=Hold K=Skipped L=Terminated M=Administrator approved N=Not Active P=Pending S=Skipped T=Terminated U=Auto approved W=Canceled X=Deleted Y=Bypassed
56	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code
57	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
58	ACTION_REASON	Character(3)	VARCHAR2(3) NOT NULL	Reason Code
59	FULL_PART_TIME	Character(1)	VARCHAR2(1) NOT NULL	Full/Part Time D=On Demand F=Full-Time P=Part-Time
60	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group
61	LASTUPDDTTM_J	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
62	HOURLY_RT	Number(19,6)	DECIMAL(18,6) NOT NULL	Hourly Rate
63	DAILY_RT	Number(19,3)	DECIMAL(18,3) NOT NULL	Daily Rate
64	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
65	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
66	HR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	HR Status A=Active I=Inactive
67	REPORTS_TO	Character(8)	VARCHAR2(8) NOT NULL	Reports To Position Number
68	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
69	SETID_JOBCODE	Character(5)	VARCHAR2(5) NOT NULL	Job Code Set ID
70	SETID_DEPT	Character(5)	VARCHAR2(5) NOT NULL	Department Set ID
71	SETID_LOCATION	Character(5)	VARCHAR2(5) NOT NULL	Location Set ID
72	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
73	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
74	POSITION_NBR	Character(8)	VARCHAR2(8) NOT NULL	Position Number
75	REG_REGION	Character(5)	VARCHAR2(5) NOT NULL	Regulatory Region
76	ESTABID	Character(12)	VARCHAR2(12) NOT NULL	Establishment ID
77	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
78	EMPLID_CURR_APPR	Character(11)	VARCHAR2(11) NOT NULL	Stores the Employee ID of the Current Approver in Federal Self-Service Transactions.
79	COUNTRY2	Character(3)	VARCHAR2(3) NOT NULL	Country