DSB_FILE_C_GER (SQL Table)	Index Back
Germany Disability File C 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 each month of a particular year (as defined on the Run Control Page) and the total number of active employees for each month. 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_C_GER

(SQL Table)

Germany Disability File C 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 each month of a particular year (as defined on the Run Control Page) and the total number of active employees for each month. 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 BTNR Character(8) VARCHAR2(8) NOT NULL Employer Social Insurance Nbr

3 MONTHCD Character(2) VARCHAR2(2) NOT NULL Month
01=01 - January
02=02 - February
03=03 - March
04=04 - April
05=05 - May
06=06 - June
07=07 - July
08=08 - August
09=09 - September
10=10 - October
11=11 - November
12=12 - December

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

5 TOTAL_ACTIVE_EE Number(9,0) DECIMAL(9) NOT NULL Total active employees. Used for Employment and Salary Verification integration file extract process.

6 TOTAL_INACTIVE_EE Number(9,0) DECIMAL(9) NOT NULL Total inactive employees. Used for Employment and Salary Verification integration file extract process.

7 COLUMN1_GER Number(6,0) INTEGER NOT NULL Numeric Column Information for Germany.

8 COLUMN2_GER Number(6,0) INTEGER NOT NULL Numeric Column Information for Germany.

9 COLUMN3_GER Number(6,0) INTEGER NOT NULL Numeric Column Information for Germany.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	BTNR	Character(8)	VARCHAR2(8) NOT NULL	Employer Social Insurance Nbr
3	MONTHCD	Character(2)	VARCHAR2(2) NOT NULL	Month 01=01 - January 02=02 - February 03=03 - March 04=04 - April 05=05 - May 06=06 - June 07=07 - July 08=08 - August 09=09 - September 10=10 - October 11=11 - November 12=12 - December
4	CALENDAR_YEAR	Number(4,0)	SMALLINT NOT NULL	Calendar Year
5	TOTAL_ACTIVE_EE	Number(9,0)	DECIMAL(9) NOT NULL	Total active employees. Used for Employment and Salary Verification integration file extract process.
6	TOTAL_INACTIVE_EE	Number(9,0)	DECIMAL(9) NOT NULL	Total inactive employees. Used for Employment and Salary Verification integration file extract process.
7	COLUMN1_GER	Number(6,0)	INTEGER NOT NULL	Numeric Column Information for Germany.
8	COLUMN2_GER	Number(6,0)	INTEGER NOT NULL	Numeric Column Information for Germany.
9	COLUMN3_GER	Number(6,0)	INTEGER NOT NULL	Numeric Column Information for Germany.