PROCESS_INSTANCEBTNRMAIN_BTNR0=Private Employer
1=Supreme Federal Authority
2=Sup Fed Auth Par 241, 1 SGB IX
3=Supreme State Authority
4=Other Public Employers
5=Pub Employer Par 241,1 SGB IX
DSB_FILE_A_GER(SQL Table) |
Index Back |
|---|---|
Germany Disability File A InfoOne 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 unique Social Insurance Number and details about that branch. This record is transformed into a csv file via File Layout DSB_FILE_LAYOUT_A_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 | MAIN_BTNR |
Character(8) | VARCHAR2(8) NOT NULL | Main Social Insurance Unit |
| 4 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Location Code |
| 5 | DSB_COMP_TYPE_GER | Character(1) | VARCHAR2(1) NOT NULL |
Company Type
0=Private Employer 1=Supreme Federal Authority 2=Sup Fed Auth Par 241, 1 SGB IX 3=Supreme State Authority 4=Other Public Employers 5=Pub Employer Par 241,1 SGB IX |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | DESCR1 | Character(30) | VARCHAR2(30) NOT NULL | Descr |
| 8 | DESCR2 | Character(30) | VARCHAR2(30) NOT NULL | Descr2 |
| 9 | HRDE_LEGAL_TYPE | Character(2) | VARCHAR2(2) NOT NULL | Placeholder Field for Company Legal Type for File Layouts |
| 10 | ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
| 11 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
| 12 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 13 | BRANCH_ID | Character(10) | VARCHAR2(10) NOT NULL | The local branch office identifier associated with a given bank/counterparty. |
| 14 | EXCLUDE | Character(1) | VARCHAR2(1) NOT NULL | Exclude |