It only depends on the division the player is transferring to. If a player transfers from any 4 year school to a D1, he typically has to sit for one year. If a player transfers from a D1 to any other division, then typically he can play immediately.
D1 rules only apply to players who are participating at a D1 school. When a player transfers, he then becomes subject to the rules of the new division.