BS31.1 | BS531 | BN305 | HR11.1 | HR11.2 | HR511 |
PA02.1 | PA100 | PA102 | PA115 | PA13.1 | PA13.2 |
PA502 | PA513 | PA52.1 | PA52.3 | PA52.4 | PA52.5 |
PR110 | PR113 | PR120 | PR13.1 | PR13.5 | PR13.6 |
PR13.8 | PR13.9 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||
---|---|---|---|---|
BNB-COMPANY Element: Company Hr | Numeric 4 |
|
||
BNB-EMPLOYEE Element: Employee | Numeric 9 Contains the employee number. Each person employed by the company is assigned a unique number. The system uses the employee number to correlate all of the information related to that person. |
|
||
BNB-PLAN-TYPE Element: Plan Type | Alpha 2 |
|
||
BNB-PLAN-CODE Element: Plan Code | Alpha 4 Contains the user-defined code that represents a benefit plan. |
|
||
BNB-START-DATE Element: Start Date | Numeric 8 (yyyymmdd) |
|
||
BNB-FC Element: Fc | Alpha 1 |
|
||
BNB-ENROLL-DATE Element: Enroll Date | Numeric 8 (yyyymmdd) |
|
||
BNB-COVER-OPT Element: Cover Opt | Numeric 2 |
|
||
BNB-MULT-SALARY Element: Mult Salary | Signed 6.3 |
|
||
BNB-COVER-AMT Element: Cover Amt | Signed 11.2 |
|
||
BNB-PAY-RATE Element: Pay Rate | Signed 13.4 |
|
||
BNB-PCT-AMT-FLAG Element: Pct Amt Flag | Alpha 1 |
|
||
BNB-PRE-AFT-FLAG Element: Pre Aft Flag | Alpha 1 |
|
||
BNB-SMOKER-FLAG Element: Smoker Flag | Alpha 1 |
|
||
BNB-EMP-PRE-CONT Element: Emp Pre Cont | Signed 11.2 |
|
||
BNB-EMP-AFT-CONT Element: Emp Aft Cont | Signed 11.2 |
|
||
BNB-STOP-DATE Element: Stop Date | Numeric 8 (yyyymmdd) |
|
||
BNB-PEND-EVIDENCE Element: Pend Evidence | Alpha 1 |
|
||
BNB-YTD-CONT Element: Ytd Cont | Signed 13.2 |
|
||
BNB-RCD-TYPE Element: Rcd Type | Numeric 2 |
|
||
BNB-PLAN-GROUP Element: Plan Group | Alpha 20 |
|
||
BNB-COP-COV-DESC Element: Cop Cov Desc | Alpha 15 |
|
||
BNB-DEP-COVER-AMT Element: Dep Cover Amt | Signed 11.2 |
|
||
BNB-COV-PCT Element: Cov Pct | Signed 5.2 |
|
||
BNB-FLEX-COST Element: Flex Cost | Signed 9.2 |
|
||
BNB-EMP-COST Element: Emp Cost | Signed 9.2 |
|
||
BNB-COMP-COST Element: Comp Cost | Signed 9.2 |
|
||
BNB-UPDATE-DATE Element: Update Date | Numeric 8 (yyyymmdd) This field contains the date the record was updated. |
|
||
BNB-ALPHADATA1 Element: Alphadata1 | Alpha 1 |
|
||
BNB-NUMERIC1 Element: Numeric1 | Signed 15.4 |
|
||
BNB-DATE1 Element: Date1 | Numeric 8 (yyyymmdd) |
|
||
BNB-PLAN-DESC Element: Plan Desc | Alpha 30 |
|
||
BNB-CURRENCY-CODE Element: Currency Code | Alpha 5 This field contains the company base currency code established in Company (GL10.1 ). |
|
||
BNB-CURR-ND Element: Acct Nd | Numeric 1 The number of decimals assigned to a particular account as determined by the account currency. |
|
||
BNB-CREATION-DATE Element: Creation Date | Numeric 8 (yyyymmdd) This is the date that this line was added to the requisition. |
|
||
BNB-UPD-DATE Element: Upd Date | Numeric 8 (yyyymmdd) |
|
||
BNB-TIME-STAMP Element: Time Stamp | Numeric 6 (hhmmss) Contains the server time (hour, minute, and second) when the record was last changed. |
|
||
BNB-USER-ID Element: User | Alpha 10 (Lower Case) |
|
||
BNB-CREATE-TRANS Element: Create Trans | Alpha 1 Y = Yes N = No |
|
||
BNB-TRAN-REASON Element: Reason | Alpha 10 |
|
||
BNB-MEMBER-ID Element: Member Id | Numeric 1 |
|
||
BNB-BN-TYPE Element: Bn Type | Alpha 1 Load pending employee actions by specific Benefit Types of 1) New Hire, 2) Open Enrollment, 3) Life Event. 1 = Annual 2 = Life Event 3 = New Hire |
|
||
BNB-HOLD-FLAG Element: Hold Flag | Alpha 1 N = No Y = Yes |
|
||
BNB-FAMILY-STATUS Element: Family Status | Alpha 10 |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
BNBSET1 |
COMPANY EMPLOYEE PLAN-TYPE PLAN-CODE START-DATE |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Company | BNCOMPANY |
Required
| ||||||||||||
Currency | CUCODES |
Required
| ||||||||||||
Employee | EMPLOYEE |
Required
| ||||||||||||
Plan | PLAN |
Required
| ||||||||||||
Reason Code | PCODES |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Depben | DEPBEN |
Delete Restricted
|
All trademarks and registered trademarks are the property of their
respective owners.