Sunday, May 11, 2008

National ID Validation

With all national ids being stored on the PERS_NID table in one field NATIONAL_ID, the format checking is performed on the field DERIVED_HD.NID_SPECIAL_CHAR by calling the function Check_NID. This in turns calls addition function based on which contry has been selected by the used.

For Canada, CheckNID_CAN is called and for US . Both are functions on FUNCLIB_HR.NATIONAL_ID ( Field Formula )

1 comment:

blogster said...

Thanks for posting. This came in handy :)