InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What Is Effective Status? |
|
Answer» EFF_STATUS usually accompanies EFFDT. For example in Department table suppose we inactivated one dept from so and so future effdt, from that future date ONWARDS this dept is GOING to be inactivated, after that whenever we click the link prompt button of dept id FIELD we can SEE only active departments. EFF_STATUS usually accompanies EFFDT. For example in Department table suppose we inactivated one dept from so and so future effdt, from that future date onwards this dept is going to be inactivated, after that whenever we click the link prompt button of dept id field we can see only active departments. |
|