Every leg has its RNP coded in the database, so the entire SID/STAR should be coded with RNP1, the final approach with RNP 0.3 and the missed approach with RNP1. All this is for a standard sequence, a certain procedure might have different RNP required and that should normally be coded in the database.
Yes, many, well all if possible, of the tailored procedures go to 0.3 beginning from the IF, final segment, (some to 0.1) and continue with same RNP level (0.3) through the missed. If RAIM cannot support the procedure through all legs, it will alarm. HIL is another variable to look at. If HIL gets outside the limit for the RNP level, it will also alarm.