DSB_FILE_D_GER (SQL Table)	Index Back
Germany Disability File D Info One of the 3 output records from Application Engine HR_DISAB_GER, which is the process for German Disability. This record is keyed by PROCESS_INSTANCE to store information from multiple runs. It also stores a row for every disabled employee employed during a particular year (as defined on the Run Control Page) and their Disability details. This record is transformed into a csv file via File Layout DSB_FILE_LAYOUT_C_GER. This file is then read by rehadat and delivered to the unemployment office.

DSB_FILE_D_GER

(SQL Table)

Germany Disability File D Info

One of the 3 output records from Application Engine HR_DISAB_GER, which is the process for German Disability. This record is keyed by PROCESS_INSTANCE to store information from multiple runs. It also stores a row for every disabled employee employed during a particular year (as defined on the Run Control Page) and their Disability details. This record is transformed into a csv file via File Layout DSB_FILE_LAYOUT_C_GER. This file is then read by rehadat and delivered to the unemployment office.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 EMPLID_CNT Number(6,0) INTEGER NOT NULL Used by Employee Survey process HR_EMSURVEY.

3 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number

4 BTNR Character(8) VARCHAR2(8) NOT NULL Employer Social Insurance Nbr

5 SEX Character(1) VARCHAR2(1) NOT NULL Gender
F=Female
M=Male
U=Unknown
X=Indeterminate/Intersex/Unspec

6 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

7 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name

8 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name

9 CITY50 Character(50) VARCHAR2(50) NOT NULL City

10 BIRTHDATE_CHAR Character(8) VARCHAR2(8) NOT NULL Birthdate Date in String Form.

11 BA_CD Character(5) VARCHAR2(5) NOT NULL BA Code

12 DESCR Character(30) VARCHAR2(30) NOT NULL Description

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

14 HIRE_DT_CHAR Character(8) VARCHAR2(8) NOT NULL Hire Date in String Form.

15 TERMINATN_DT_CHAR Character(8) VARCHAR2(8) NOT NULL Termination Date in String Form.

16 DISABLED_TYPE_GER Character(5) VARCHAR2(5) NOT NULL Disabled Type for Germany

17 DIS_STATUS_OFFICE5 Character(5) VARCHAR2(5) NOT NULL 5 Character Status Office

18 CITY Character(30) VARCHAR2(30) NOT NULL City

19 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal

20 DISABILITY_CARD_NO Character(25) VARCHAR2(25) NOT NULL Disability Card Number

21 CARD_ISSUE_DT_CHAR Character(8) VARCHAR2(8) NOT NULL Card Issue Date

22 CARD_EXP_DT_CHAR Character(8) VARCHAR2(8) NOT NULL Card Expiration Date in String form.

23 DISAB_EVAL_DT_CHAR Character(8) VARCHAR2(8) NOT NULL Disability Evaluation Date in String Form.

24 APPRENTICE Character(1) VARCHAR2(1) NOT NULL Apprentice-level Employee
N=None
Y=Apprentice
Y/N Table Edit
Default Value: N

25 APP_BGN_DT_CHAR Character(8) VARCHAR2(8) NOT NULL Apprenticeship Begin date in String form.

26 APP_END_DT_CHAR Character(8) VARCHAR2(8) NOT NULL Apprenticeship End date in String form.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	EMPLID_CNT	Number(6,0)	INTEGER NOT NULL	Used by Employee Survey process HR_EMSURVEY.
3	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
4	BTNR	Character(8)	VARCHAR2(8) NOT NULL	Employer Social Insurance Nbr
5	SEX	Character(1)	VARCHAR2(1) NOT NULL	Gender F=Female M=Male U=Unknown X=Indeterminate/Intersex/Unspec
6	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
7	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
8	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
9	CITY50	Character(50)	VARCHAR2(50) NOT NULL	City
10	BIRTHDATE_CHAR	Character(8)	VARCHAR2(8) NOT NULL	Birthdate Date in String Form.
11	BA_CD	Character(5)	VARCHAR2(5) NOT NULL	BA Code
12	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
13	FULL_PART_TIME	Character(1)	VARCHAR2(1) NOT NULL	Full/Part Time D=On Demand F=Full-Time P=Part-Time
14	HIRE_DT_CHAR	Character(8)	VARCHAR2(8) NOT NULL	Hire Date in String Form.
15	TERMINATN_DT_CHAR	Character(8)	VARCHAR2(8) NOT NULL	Termination Date in String Form.
16	DISABLED_TYPE_GER	Character(5)	VARCHAR2(5) NOT NULL	Disabled Type for Germany
17	DIS_STATUS_OFFICE5	Character(5)	VARCHAR2(5) NOT NULL	5 Character Status Office
18	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
19	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
20	DISABILITY_CARD_NO	Character(25)	VARCHAR2(25) NOT NULL	Disability Card Number
21	CARD_ISSUE_DT_CHAR	Character(8)	VARCHAR2(8) NOT NULL	Card Issue Date
22	CARD_EXP_DT_CHAR	Character(8)	VARCHAR2(8) NOT NULL	Card Expiration Date in String form.
23	DISAB_EVAL_DT_CHAR	Character(8)	VARCHAR2(8) NOT NULL	Disability Evaluation Date in String Form.
24	APPRENTICE	Character(1)	VARCHAR2(1) NOT NULL	Apprentice-level Employee N=None Y=Apprentice Y/N Table Edit Default Value: N
25	APP_BGN_DT_CHAR	Character(8)	VARCHAR2(8) NOT NULL	Apprenticeship Begin date in String form.
26	APP_END_DT_CHAR	Character(8)	VARCHAR2(8) NOT NULL	Apprenticeship End date in String form.